You are a database administrator of a Microsoft SQLServer 2012 environment. The environment contains two
servers named SQLServer01 and SQLServer02. The database Contoso exists on SQLServer01. You plan to
mirror the Contoso database between SQLServer01 andSQLServer02 by using database mirroring. You need
to prepare the Contoso database for database mirroring. 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.)
Build List and Reorder:
Answer:
Explanation:
1. Perform FULL backup of Contoso DB on Server01
2. Perform TRANSACTION LOG backup of Contoso DB on Server01
3. Restore FULL backup of Contoso DB to Server02 (as Contoso DB) WITH NORECOVERY option
4. Restore TRANSACTION LOG backup (from Server01) to Server02, WITH NORECOVERY option
5. Perform a FULL backup of Server02
0
0