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 to a new
server instance 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.)
