Which options should you select on the Options page of the Restore Database window?

HOTSPOT

You administer a Microsoft SQL Server database. The database is in the Simple recovery mode.

You schedule the following backup plan:

– Full backup every day at midnight

– Differential backups every hour on the hour, except at midnight

The database fails at 20:45 hours.

You need to use SQL Server Management Studio (SSMS) to begin restoring the database with a minimum amount of data loss.

Which options should you select on the Options page of the Restore Database window? (To answer, configure the appropriate option or options in the dialog box in the answer area.)

View Answer

Answer:

Explanation:

First, restore full database backup, differential database backup and all transaction log backups WITH NORECOVERY Option. After that, bring back database online using WITH RECOVERY option.

References: https://blog.sqlauthority.com/2009/07/15/sql-server-restore-sequence-and­understanding-norecovery-and-recovery/