Which three actions should you perform in sequence?

DRAG DROP

You administer a Microsoft SQL Server 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.)

View Answer

Answer: