You maintain a SQL Server 2008 instance that contains a database named Finance. The
recovery model of the Finance database is set to Full.
The backup strategy for the Finance database is as shown in the following table.
The system databases, user database data, and log files are stored on separate disks. The
hard disks that contain the user database data files are reported to have failed at 15:00
hours on Wednesday.
You need to restore the Finance database from the database backups by ensuring minimal
data loss in minimum possible time.
What should you do?
A.
Restore the full backup taken on Sunday. Restore the differential backup taken on
Wednesday.
B.
Back up the transaction log. Restore the full backup taken on Sunday. Restore all
transaction log backups.
C.
Restore the full backup taken on Sunday.
Restore the differential backup taken on Monday and Tuesday. Restore the transaction log
backups taken at 08:00 hours and at 12:00 hours on Wednesday.
D.
Back up the transaction log. Restore the full backup taken on Sunday. Restore the
differential backup taken on Tuesday. Restore all transaction log backups taken during
Wednesday