DRAG DROP
You administer a Microsoft SQL Server 2012 environment that contains a production SQL Server
2005 instance named SQL2005 and a development SQL Server 2012 instance named SQL2012.
The development team develops a new application that uses the SQL Server 2012 functionality. You
are planning to migrate a database from SQL2005 to SQL2012 so that the development team can
test their new application.
You need to migrate the database without affecting the production environment.
Which three actions should you perform in sequence? (To answer, move the appropriate actions
from the list of actions to the answer area and arrange them in the correct order.)
Explanation:
http://msdn.microsoft.com/en-us/library/ms177429.aspx
Is this question right?
I think we should use:
– perform a full backup
– Restore the full backup
– change to 110
“You need to migrate the database without affecting the production environment.”
I think the sequence should be
-VSS backup 2005
-Restore VSS backup 2012
-change to 110
The reason being, VSS backups are used to back up databases while applications are still running and altering the database.
https://technet.microsoft.com/en-us/library/ee923636(v=ws.10).aspx
I agree with Matt: performing a full backup on the SQL 2005 production database will affect the backup chain, as the “Copy only” option has been introduced with SQL Server 2008.
I think presented answers are correct.
First, there is no information that production database use Full recovery model, so there is no problem with using full backup. Restoring full and trans log backup on 2012 looks like trick answer, but it is correct answer.
VSS backup is not include in this exam prep documentation, so If you were not working with it before, you will not learn about it during this exam preps.
why to change the compatibility level?
if you go down from 2012 to 2005 you change it
but when you go up from 2005 to 2012 why to change?
See the link, please: https://msdn.microsoft.com/en-us/library/bb510680.aspx
When a database is upgraded from any earlier version of SQL Server, the database retains its existing compatibility level if it is at least minimum allowed for that instance of SQL Server. Upgrading a database with a compatibility level lower than the allowed level, sets the database to the lowest compatibility level allowed.(c)
So, to use the sql server 2012 functionality you should manually upgrade the compatibility level. The answer is correct.
2-1-5
if you restore a SQL Server 2005 or SQL Server 2008 database to SQL Server 2012, the database is automatically upgraded
i tested this out and my previous reply was incorrect. you must manually upgrade the compatibility level.