DRAG DROP
You administer a Microsoft SQL Server 2012 database.
The database is backed up according to the following schedule:
Daily full backup at 23:00 hours.
Differential backups on the hour, except at 23:00 hours.
Log backups every 10 minutes from the hour, except on the hour.
The database uses the Full recovery model.
A developer accidentally drops a number of tables and stored procedures from the database
between 22:40 hours and 23:10 hours. You perform a database restore at 23:30 hours to
recover the dropped table.
You need to restore the database by using the minimum amount of administrative effort.
You also need to ensure minimal data loss.
Which three actions should you perform in sequence? (To answer, move the appropriate
actions from the list of actions to the answer area and arrange them in the correct order.)
Answer: 
The 3rd answer could NEVER be right. The first two are correct. If you restored the XLog between those hours, you would bring the database state right back to where it was before the restore – with the dropped tables and stored procedures. One big time wasting looop……
0
0
I’m confused. The tables aren’t dropped until after 22:40, so how does restoring the transaction logs between 22:00 – 22:40 bring the db back to where it was before the restore?
0
0
Maybe, tables might have been dropped at 22:40 during the XLog backup, but I think that the answer is correct is this case.
The question could be made better (for example saying that the tables had been dropped from 22:45)
0
0
I have the same question.
0
0
I agree.
Another point is why not the first step to be “Restore the most recent Full backup”? It’s essentially the same as “Restore full backup from previous night”, isn’t it ? Providing tow same options in the question is wrong.
0
0
tow should be read two in previous post (typo)
0
0
The most recent backup is at 23:00 of the same night. Tables started dropping at 22:40, 20 minutes before this backup. So, you need the backup from the previous night. Then the 22:00 differential Then log backups to 22:40, of which there should be 4.
0
0
I have a question, can it only restore the differential backup taken at 22:00 hours? Because between the full backup on previous night and today 22:00 hours, there are still a set of differential backup
0
0