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 database server named Certkiller -DB01, and a file server named Certkiller -SR22. Certkiller -DB01 runs SQL Server 2005 Workgroup Edition and 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 implement a backup strategy for the CK_Sales database that includes log shipping. You successfully install SQL Server 2005 Workgroup Edition on a new database server named Certkiller -DB02.
What should you do next?
A.
Create a database instance on Certkiller -DB02.
B.
Perform a full backup of the CK_Sales database on Certkiller -DB01 and restore it to Certkiller -DB02.
C.
Configure Certkiller -DB01 and Certkiller -DB02 as active nodes.
D.
Reproduce the user login from Certkiller -DB01 on Certkiller -DB02.
Explanation:
Log shipping requires that the primary database be backed up and restored to the secondary database server. This can be done automatically when you configure the secondary server for log shipping, or it can be done manually.
Incorrect Answers:
A: You have already installed SQL Server 2005 on Certkiller -DB02. You must create the initial database instance when you install SQL Server 2005.
C: Failover clustering uses nodes, not log shipping.
D: Database mirroring with failover may require that you reproduce the user login from Certkiller -DB01 on Certkiller -DB02. Log shipping does not have this requirement as it is a passive recovery mechanism that does not support automatic failover.
Reference:
Microsoft SQL Server 2005 Books Online (2006), Index: log shipping [SQL Server], configuring