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 instance is managed by you. And a large database is hosted by the instance.
The company utilizes the following backup strategy for the database.
First, the performance of a full database backup is implemented at 02:00 hr every Monday.
Secondly, the performance of a differential backup is implemented at 23:00 hr every day.
Thirdly, the performance of a transaction log backup is implemented on an hourly basis.
A reboot is caused on the SQL Server 2008 server by a power failure at 09:15 hr, Thursday.
Fifteen minutes after the reboot of the server, it is reported that certain queries that access customer data cannot be executed.
You find that the customer data remains unvaried after the power failure.
When the DBCC CHECKDB command is executed on the database, the following error message is received.
Object ID 2814307832,
index ID 2,
partition ID 83127819437122157,
alloc unit ID 82134587923221126 (type In-row data): Page (3421:169) could not be processed.
See other errors for details.
Table error: Object ID 2814307832, index ID 2, partition ID 83127819437122157, alloc unit ID
82134587923221126 (type In-row data), page (3421:169).
Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed.
Values are 16928422 and -8.CHECKDB found 0 allocation errors and 2 consistency errors in table
‘tbl_Customer’ (object ID 2814307832).
When the sp_help ‘tbl_customer’ stored procedure is executed, the following result set is received:
index_name index_description
PK clustered located on PRIMARY
NCIX nonclustered located on PRIMARY
Since you are the technical support, you are required to make sure that the data should be accessible in the shortest time. And the impact on users should be cut to the least.
Which action will you perform to finish the task?
A.
To finish the task, the PK index should be dropped and recreated.
B.
To finish the task, the latest full database backup should be recovered. And all transaction log backups should be recovered from the latest full database backup.
C.
To finish the task, the latest full database backup should be recovered. And then, the latest differential backup should be recovered. At last, all transaction log backups should be recovered from the latest differential backup.
D.
To finish the task, the NCIX index should be dropped and recreated.