You have a database named Sales set to use the Full recovery

You have a database named Sales set to use the Full recovery model. This is not a very big database-only about 200 MB-so you perform a full backup of this database every night and transaction log backups every two hours during the day starting at 8:00 AM. At 12:30 PM on Tuesday you have a power surge, and the Sales database becomes corrupted. How should you restore the database to get to the most current state?

a. Restore the full backup from Monday night.
b. Restore the full backup from Monday night, next restore the 12:00 PM transaction log backup, then restore the 10:00 AM transaction log backup, and finally restore the 12:00 PM transaction log backup.
c. Restore the full backup from Monday night, next restore the 8:00 AM transaction log backup, then restore 10:00 AM transaction log backup, and finally restore the 12:00 PM transaction log backup.
d. Restore the 8:00 AM transaction log backup, next restore the 10:00 AM transaction log backup, and finally restore the 12:00 PM transaction log on.

Solution

Step 1 :

The data lost on tuesday,  we can perform restore the full backup from Monday night.

Step 2 :

Since transaction log backups every two hours during the day start at 8:00 AM, so start the back up process start from 8:00 AM on tuesday.

Step 3 :

Restore the 8:00 AM transaction log backup, then restore 10:00 AM transaction log backup, and finally restore the 12:00 PM transaction log backup.

Option c is correct choice.