You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance that contains a database named ABC_DB. The backup of ABC_DB is as follows:
•Full backup at 17:00
•Differential backup at 19:00
•Database snapshots at 20:00 and 21:00
Furthermore, the backups and the database snapshots are reserved on a different disk. However,
ABC_DB has failed at 20:10. You have received instruction to recover ABC_DB .
What steps should you take to keep the data loss minimum?
A.
You should consider recovering the Differential backup files only.
B.
You should consider recovering the Full backup and the differential backup files.
C.
You should consider recovering the Full backup files only.
D.
You should consider recovering the database snapshot from 21:00.
E.
You should consider recovering the database snapshot from 20:00.
Explanation:
A database-snapshot can easily be reverted to the DB as long as the DB itself is properly running.
A “failed DB” (which reason ? disk error ?) must be restored from backup first.