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
✑ Transaction log backups every ten minutes, starting 10 minutes from the hour, except on the hour
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.)
Hot Area:
- Hotspot You Adm 1 (74.17 KiB) Viewed 82 times