DRAG DROP
You administer a Microsoft SQL Server 2008 R2 database that contains customer invoice
accounts.
Backups are performed according to the following schedule:
-Full database backup at 00:00 hours daily. -Transaction log backups at 06:00 hours, 14:00
hours, and 20:00 hours daily.
You discover that the database failed at 11:59 hours. You also discover that the database is
no longer accessible due to a failure of the hard disk drive that contains the database data
file.
You need to restore the database. You also need to ensure that data loss is minimal.
Which four 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:

Box 1:

Box 2:

Box 3:

Box 4:

Note: Backup the tail of the transaction log (backup log to file=”…” with NORECOVERY,
NO_TRUNCATE)Restore your full DB backup with no recovery.Restore your Diff backup
with no recovery (if applicable)Restore all your tran logs backups, in sequence, all with no
recoveryRestore the backup you made of the tail of the log, with recovery