You are a professional level SQL Sever 2008 Database Administrator in an international corporation
named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing
and sustaining the database life cycle.
In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization.
A SQL Server 2008 database solution is managed by you, and 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 bring the secondary database online.
B.
You should execute the DBCC CHECKDB command along with the REPAIR_REBUILD option against the primary database.
C.
You should perform the tail-log backup of the primary database.
D.
You should execute the DBCC CHECKDB command along with the REPAIR_ALLOW_DATA_LOSS option against the primary database.