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 and all client computers run Windows XP Professional. The Domain.com network contains a SQL Server 2005 database server named Certkiller -DB01. Certkiller -DB01 hosts a database named CK_Sales that stores sales data for the company. You install two new SQL Server 2005 database server named Certkiller -DB02 and Certkiller -DB03 on the Domain.com network. You want to configure log shipping between the three database servers with Certkiller -DB01 being the primary server. You want users to be able to use Certkiller -DB02 and Certkiller -DB03 to run queries and reports against the CK_Sales database. You backup the CK_Sales database and all transaction logs on Certkiller -DB01.
What should you do next?
A.
Leave the database in RECOVERY mode when restoring the backups of the CK_Sales database and transaction logs to Certkiller -DB02 and Certkiller -DB03.
B.
Leave the database in NORECOVERY mode when restoring the backups of the CK_Sales database and transaction logs to Certkiller -DB02 and Certkiller -DB03.
C.
Leave the database in STANDBY mode when restoring the backups of the CK_Sales database and transaction logs to Certkiller -DB02 and Certkiller -DB03.
D.
Leave the database in READ-ONLY mode when restoring the backups of the CK_Sales database and transaction logs to Certkiller -DB02 and Certkiller -DB03.
Explanation:
STANDBY mode allows read-only access to the secondary server that can be used for read-only query processing. This can be used to reduce the load on the primary server.
Incorrect Answers:
A, D: Restore operation in SQL Server 2005 does not support RECOVERY or READ-ONLY modes.
B: The execution of queries and reports are not supported on a database that is in NORECOVERY mode.
Reference:
Microsoft SQL Server 2005 Books Online (2006), Index: log shipping [SQL Server], secondary servers