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.
You want to implement a recovery model and backup strategy for the CK_Sales database. You decide to add a second database server named Certkiller -DB02 to the Domain.com network. You install SQL Server 2005 Workgroup Edition on Certkiller -DB02.
What should you do next?
A.
Configure Certkiller -DB01 and Certkiller -DB02 for log shipping.
B.
Configure database mirroring on Certkiller -DB01 and Certkiller -DB02.
C.
Configure Certkiller -DB01 and Certkiller -DB02 in a failover cluster with two active nodes.
D.
Configure Certkiller -DB01 and Certkiller -DB02 for snapshot replication.
Explanation:
Of the available options, the only backup and recovery mechanism supported by SQL Server 2005 Workgroup Edition is log shipping.
Incorrect Answers:
B, D: Database mirroring and failover clustering requires SQL Server 2005 Standard Edition or SQL Server 2005 Enterprise Edition.
C: Snapshot replication requires SQL Server 2005 Enterprise Edition.
Reference:
Microsoft SQL Server 2005 Books Online (2006), Index: features [SQL Server]