You administer a Microsoft SQL Server 2008 R2 instance.
A disk drive that contains the files for the database is lost. The drive has been replaced, but
the data files have been irrevocably lost.
You need to restore the database.
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.