You administer a SQL Server 2008 database solution that is log-shipped for high-availability
purposes. The data files of the database are located on drive D. The transaction log files of
the database are located on drive E. You are designing a recovery test plan to meet the
following requirements for the log-shipping solution: The secondary database is brought
online as quickly as possible. The data loss is minimal. The data is in a consistent state.
You need to identify the first step for the recovery test plan when drive D fails. Which step
should you choose?
A.
Bring the secondary database online.
B.
Perform the tail-log backup of the primary database.
C.
Execute the DBCC CHECKDB command along with the REPAIR_REBUILD option
against the primary database.
D.
Execute the DBCC CHECKDB command along with the REPAIR_ALLOW_DATA_LOSS
option against the primary database.