You administer a Microsoft SQL Server 2008 R2 instance. The instance has a database
named CustomerOrders.
The database is backed up by using the weekly scheduled SQL Server Agent jobs.
The backup schedule is shown in the following table: A drive fails and the CustomerOrders
database goes into suspect mode on Thursday at 17:00 hours.
You need to restore the backup.
What should you do?
A.
Restore the backup taken on Sunday only.
B.
Restore the backups taken on Sunday and Monday.
C.
Restore the backup taken on Wednesday only.
D.
Restore the backups taken on Wednesday, Thursday at 09:00 hours, and Thursday at
18:00 hours.
E.
Restore the backups taken on Wednesday and Thursday at 09:00 hours.
F.
Restore the backups taken on Wednesday, Thursday, and Friday.
G.
Restore the backups taken on Wednesday and Friday.
H.
Restore the backups taken Wednesday, Friday, and Saturday.
Explanation: