You manage an instance of SQL Server 2008 named SQL1 . SQL1 contains a database named Sales . You wantto configure database mirroring for the Sales database.
You install a new instance of SQL Server 2008 on aserver named Server2 . You perform a full backup of the Sales database and its transaction logs.
What should do to create the mirror database on Server2 ? (Choose two. Each correct answer presents part ofthe solution.)
A.
Restore the backup of the Sales database with the same name on Server2 by using the WITH NO RECOVERY clause.
B.
Restore the backup of the Sales database with the same name on Server2 by using the WITH STANDBY clause.
C.
Apply the transaction log backup to the Sales database on Server2 by using the WITH NO RECOVERY clause.
D.
Apply the transaction log backup to the Sales database on Server2 by using the WITH STANDBY clause.
Explanation:
You should restore the backup of the Sales database with the same name on Server2 by using the WITHNORECOVERY clause and then apply the transaction log backup to the
Sales database on Server2 by using the WITH NORECOVERY clause. Database mirroring is primarily used for high availability of databases. Databasemirroring can only be implemented on a per-database basis for databases that are configured with the FullRecovery model. Database mirroring is not supported by the Bulk-Logged and Simple Recovery models. A database mirroring session operates by using either synchronous or asynchronous mode. In synchronous orhigh-safety mode, a transaction is committed on both servers, which ensures that the mirror database is insynchronization with the principal database. In asynchronous or high-performance mode, the transactions commitwithout waiting for the mirror server to write the log to disk. Therefore, the asynchronous mode maximizesperformance by supporting large volumes of transactions. To ensure that a mirroring session can be established,you must ensure that the mirror database is created and is configured for mirroring. To create a new mirrordatabase, a full backup of the principal database and its transaction log backup must be restored onto the mirrorserver instance by using the WITH NORECOVERY clause.
You should not restore the backup of the Sales database with the same name on Server2 by using the WITHSTANDBY clause or apply the transaction log backup to the Sales
database on Server2 by using the WITHSTANDBY clause. Creating a new mirror database requires a full backup of the principal database and itstransaction log backup to berestored onto the mirror server instance by using the WITH NORECOVERY clause.Objective:
Implementing High AvailabilitySub-Objective:
Implement database mirroring.References:
MSDN > MSDN Library > Servers and Enterprise Development > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Database Engine > Operations > High Availability > DatabaseMirroring > Database Mirroring Deployment > Setting Up Database Mirroring > Preparing a Mirror Database forMirroring MSDN > MSDN Library > Servers and Enterprise Development > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Database Engine > Operations > High Availability > DatabaseMirroring > Database Mirroring Overview