Which three actions should you perform in sequence?

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.)
Select and Place:

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.)
Select and Place:

Answer:

Explanation:



Leave a Reply 6

Your email address will not be published. Required fields are marked *


Alex

Alex

What does it mean “Perform a full database” ? – there is no word “backup”. May be VSS backup and restore?

Brian K

Brian K

The question says to choose 3. Answer is correct besides the “Perform a trans..” step.

Brian K

Brian K

Nevermind…

JosefTheGreat

JosefTheGreat

the question says: “You need to migrate the database without affecting the production environment.”

In this case I would use a VSS backup!

VSS is a framework that consists of a set of interfaces and structures that enable applications to perform backups of volumes while other applications use the data in these volumes. VSS is included with Microsoft Windows XP and Microsoft Windows Server 2003.

I would take answers: 3-4-7

JosefTheGreat

JosefTheGreat

I want to correct myself… after further research you should restore the full backup and the transactional backup too. 2-5-7 schould be right

Razor

Razor

What will be correct steps? As per Josef, don’t we need to set the compatibility level to 110?