You manage an instance of SQL Server 2008 named SQL1. SQL1 contains a database named Sales. You want to configure database mirroring for the Sales database. You install a new instance of SQL Server 2008 on a server 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 of the solution.)
A.
Restore the backup of the Sales database with the same name on Server2 by using the WITH NORECOVERY 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 NORECOVERY 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 WITH NORECOVERY 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. Database mirroring can only be implemented on a per-database basis for databases that are configured with the Full Recovery 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 or high-safety mode, a transaction is committed on both servers, which ensures that the mirror database is in synchronization with the principal database. In asynchronous or high-performance mode, the transactions commit without waiting for the mirror server to write the log to disk. Therefore, the asynchronous mode maximizes performance 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 mirror database, a full backup of the principal database and its transaction log backup must be restored onto the mirror server 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 WITH STANDBY clause or apply the transaction log backup to the Sales database on Server2 by using the WITH STANDBY clause. Creating a new mirror database requires a full backup of the principal database and its transaction log backup to be restored onto the mirror server instance by using the WITH NORECOVERY clause.Objective: Implementing High Availability Sub-Objective: Implement database mirroring.
References: MSDN > MSDN Library > Servers and Enterprise Development > SQL Server > SQL Server 2008 > Product Documentation > SQL Server 2008 Books Online > Database Engine > Operations > High Availability > Database Mirroring > Database Mirroring Deployment > Setting Up Database Mirroring > Preparing a Mirror Database for Mirroring MSDN > MSDN Library > Servers and Enterprise Development > SQL Server > SQL Server 2008 > Product Documentation > SQL Server 2008 Books Online > Database Engine > Operations > High Availability > Database Mirroring > Database Mirroring Overview