You work as the database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. All servers on the Domain.com network run Windows Server2003. The Domain.com network contains a single SQL Server 2005 database server named Certkiller -DB01. Certkiller -DB01 hosts a database named CK_Sales that stores sales data for the company. The CK_Sales database is configured to use the full recovery model.
You want to provide zero down time and high availability for the CK_Sales database. You decide to add a new database server which will be named Certkiller -DB02 on the Domain.com network. You want to configure Certkiller -DB01 and Certkiller -DB02 as mirrored servers. You perform a full backup of the CK_Sales database on Certkiller -DB01.
What should you do next on Certkiller -SR02?
A.
Install SQL Server 2005 and create a database instance.
B.
Restore the full backup of CK_Sales to Certkiller -DB02.
C.
Configure the database mirroring endpoint.
D.
Reproduce the user login from Certkiller -DB01 on Certkiller -DB02.
Explanation:
Before you can implement mirrored servers, both servers must be running the same version of SQL Server 2005 (either Standard Edition, or Enterprise Edition) and each server must have a database instance.
Incorrect Answers:
B: You must first create a database instance on Certkiller -DB02 before you restore the full backup to Certkiller -DB02.
C: You must first create a database instance on Certkiller -DB02 and restore the full backup of the principle database to Certkiller -DB02 before you configure the database mirroring endpoint.
D: You must first create a database instance on Certkiller -DB02 and restore the full backup of the principal database to Certkiller -DB02 before you reproduce the user login from Certkiller -DB01 on Certkiller -DB02.
Reference:
Microsoft SQL Server 2005 Books Online (2006), Index: database mirroring [SQL Server], mirror database creation