You administer a Microsoft SQL Server 2008 R2 instance.
The database has been marked as suspect.
You need to place the database into an EMERGENCY state for troubleshooting.
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 CHECKDBalong with the REPAIR_REBUILDclause.
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.