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:

Explanation:
Reference:
http://msdn.microsoft.com/en-us/library/ms187048.aspx
http://msdn.microsoft.com/en-us/library/ms186289.aspx
http://msdn.microsoft.com/en-us/library/ms175477.aspx
http://msdn.microsoft.com/en-us/library/ms189860.aspx
http://msdn.microsoft.com/en-us/library/ms179314.aspx
http://msdn.microsoft.com/en-us/library/ms175526.aspx

http://msdn.microsoft.com/en-us/library/ms191539.aspx
http://msdn.microsoft.com/en-us/library/ms191429.aspx
http://msdn.microsoft.com/en-us/library/ms191253.aspx