Which three actions should you perform in sequence?

DRAG DROP
You are a database administrator of a Microsoft SQL Server 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 and SQLServer02 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.)

DRAG DROP
You are a database administrator of a Microsoft SQL Server 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 and SQLServer02 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.)

Answer:

Explanation:
According to these references, this answer looks correct.
http://msdn.microsoft.com/en-us/library/ms190941.aspx
http://msdn.microsoft.com/en-us/library/ms189852.aspx



Leave a Reply 5

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


God

God

1 – 5 – 4

Kevin

Kevin

Answer seems correct

Manuel

Manuel

I think the answer is incorrect. To put online the database, the transaction log restore must use the RECOVERY option, as far as I know…..So I think the correct answer is 1-5-3

David

David

Manuel, to configure mirroring you don’t need recovery the database. So the correct answer is 1 – 5 – 4