exam questions

Exam 70-462 All Questions

View all questions & answers for the 70-462 exam

Exam 70-462 topic 1 question 16 discussion

Actual exam question from Microsoft's 70-462
Question #: 16
Topic #: 1
[All 70-462 Questions]

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

Show Suggested Answer Hide Answer
Suggested Answer:
Reference:
http://msdn.microsoft.com/en-us/library/ms177429.aspx

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Selam
Highly Voted 5 years, 3 months ago
1. Perform a FULL database on SQL2005 2. Restore the database backup and transaction log backup on SQL2012. 3. Change The Compatibility level to 110.
upvoted 10 times
...
Awoke
Most Recent 4 years, 4 months ago
1.Perform a full database backup on SQL 22005 2.Perform Transaction log backup on SQL 2005 3.Resore the Full database backup and Transaction log backup on SQL 2012
upvoted 1 times
...
Fame
4 years, 9 months ago
You cannot change the compatibility level while users are connected. On the scenario, it is mentioned that you should not affect the production environment. The steps to change the compatibility level are the following and it is against the scenario. 1. Change the database to single-user mode. 2. Change the compatibility level. 3. Put the database in multi-user mode.
upvoted 1 times
...
Varad
5 years, 7 months ago
1. Perform a FULL database on SQL2005 2. Perform a Transaction Log on SQL2005 3. Restore the database backup and transaction log backup on SQL2012. Note: 1. VSS backup cannot be done for a single database 2. Compatibility level is changed automatically if required by the SQL Server. Reference: https://blogs.msdn.microsoft.com/ialonso/2015/04/17/sql-server-2005-upgrade-to-sql-server-2014-and-compatibility-levels/
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago