Microsoft
70-432 · Question #213
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…
The correct answer is F. Restore the database from the most recent full backup. Apply any differential and log backups. See the full explanation below for the reasoning.
Question
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?
Options
- AExecute sp_helpfile.
- BExecute DBCC CHECKDB.
- CExamine the msdb..suspect_pagestable.
- DExecute DBCC CHECKDBalong with the REPAIR_FASTclause.
- EExecute DBCC CHECKDBalong with the REPAIR_REBUILDclause.
- FRestore the database from the most recent full backup. Apply any differential and log backups.
- GUse the ALTER DATABASEstatement along with the SET EMERGENCYclause.
- HUse the RESTORE DATABASEstatement along with the PAGESclause.
How the community answered
(35 responses)- A3% (1)
- C3% (1)
- D9% (3)
- F74% (26)
- H11% (4)
Community Discussion
No community discussion yet for this question.