You are a professional level SQL Sever 2008 Database Administrator. The solution is
log-shipped for high-availability purposes. The data files of the database reside on drive D,
while the transaction log files of the database reside on drive E. A restoring test plan should
be implemented to satisfy the requirements listed below for the log-shipping solution. First,
the secondary database is brought online in the shortest time. Secondly, the data is in a
consistent state. Thirdly, the data loss is reduced to the least. The first step for the recovery
test plan should be identified in the event of drive D failure. Which step should be
performed?
A.
You should perform the tail-log backup of the primary database.
B.
You should execute the DBCC CHECKDB command along with the
REPAIR_ALLOW_DATA_LOSS option against the primary database.
C.
You should bring the secondary database online.
D.
You should execute the DBCC CHECKDB command along with the REPAIR_REBUILD
option against the primary database.