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:
According to these references, this answer looks correct.
References:
http://msdn.microsoft.com/en-us/library/ms190941.aspx
http://msdn.microsoft.com/en-us/library/ms189852.aspx
I think the answer choice in the first step is incorrect. When you perform a transaction log backup using the NORECOVERY option, the Principal Database would mark as NO RECOVERY which means the Principal (PrimaryDB) cannot be accessed and this shouldn’t be an option on Production Server. Our intention is to keep the Principal (PrimaryDB) database LIVE without any interruption and initiate Mirroring seamlessly. That’s my understanding.
@MSUser
“When you perform a transaction log backup using the NORECOVERY option, the Principal Database would mark as NO RECOVERY which means the Principal (PrimaryDB) cannot be accessed and this shouldn’t be an option on Production Server.”
I do not think there is such a thing as backup with NORECOVERY, only restore with NORECOVERY. The point of NORECOVERY is to prevent the database can be altered during the restore which could break the recoverysequence.
So I believe the first answer is correct.
http://technet.microsoft.com/en-us/library/ms189053(v=sql.110).aspx
There is a such thing as a LOG backup with no recovery – I don’t think it works here though.
Step 15
In the Transaction log section, check Back up the tail of the log, and leave database in the restoring state.
This is equivalent to specifying the following BACKUP Transact-SQL statement:
BACKUP LOG database_name TO WITH NORECOVERY
https://technet.microsoft.com/en-us/library/dd297499%28v=sql.105%29.aspx
is this correct?
this answer is correct!
@Kanthony thanks for the link.
Link is below again:
https://technet.microsoft.com/en-us/library/ms181075.aspx