You are the administrator of your company network. There’s a SQL Server 2008 database solution which is log-shipped for high-availability purposes. The transaction log files of the database are located on drive E. The data files of the database are located on drive D. You are developing a recovery test plan for the log-shipping solution which has to satisfy the requirements bellow. The data should be in a consistent state. The data loss should be reduced to the least. The secondary database is brought online as quickly as possible. When drive D fails, you must choose what you should do first for the recovery plan. So which step should you do?
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.