You work as a database administrator at TestKing.com. You are responsible for managing a SQL Server 2008 instance that hosts a database named TK_Process. You have implemented the following backup strategy for TK_Process:
1. A full database backup that takes approximately 90 minutes to complete is performed at
21:00 every Tuesday, Thursday and Saturday.
2. A differential backup that takes approximately 40 minutes to complete is performed at 21:00 every Monday, Wednesday and Sunday.
3. A transaction log backup that takes less than 5 minutes to complete is performed every hour.
You schedule a batch process to run at 21:00 on Tuesday. This process requires approximately 100 minutes to complete. However, a TestKing.com user modifies some data at
21:03 on the same day and the batch process is invalidated. You want to restore the database to its origin state as quickly as possible.
What should you do?
A.
You should restore the full database backup which was performed on Tuesday.
B.
You should restore the full database backup that was performed on Tuesday and then restore all transaction logs performed after Tuesday’s full backup (stop at before 21:03).
C.
You should restore the full database backup which was performed on Thursday and then restore all transaction logs performed after Thursday’s full backup (stop at before 21:03).
D.
You should restore the full database backup that was performed on Saturday, then restore the differential backup that was performed on Monday, and then restore all transaction logs performed after Monday’s differential backup (stop at before 21:03).