You administer a Microsoft SQL Server 2008 R2 instance.
You need to rectify a damaged index without losing any data.
What should you do?
A.
Execute sp_helpfile.
B.
Execute DBCC CHECKDB.
C.
Examine the msdb..suspect_pagestable.
D.
Execute DBCC CHECKDBalong with the REPAIR_FASTclause.
E.
Execute DBCC CHECKDB along with the REPAIR_REBUILDcla.se
F.
Restore the database from the most recent full backup. Apply any differential and log
backups.
G.
Use the ALTER DATABASEstatement along with the SET EMERGENCYclause.
H.
Use the RESTORE DATABASEstatement along with the PAGESclause. Create a new log
backup. Apply all differential and log backups, including the most recent backup.
I.
Use the RESTORE DATABASEstatement along with the PAGESclause. Apply any
differential and log backups. Create a new log backup and then restore the new log backup.
Explanation: