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.)
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 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.)
NO RECOVERY
Check comments here
http://www.aiotestking.com/microsoft/which-options-should-you-select-on-the-options-page-of-the-restore-database-window/
1. Restore the database to a new server instance: uncheck the box “Overwrite the existing database (WITH REPLACE)”
2. During DB restore, access restriction is desirable, so check the box “Restict access to the restored database”
3.Select the RESTORE WITH NORECOVERY option. This leaves the database in a restoring state after the restore has completed; it enables you restore additional files (differential, logs), in order to minimize data loss.
————–
Point 1. and 3. are totally correct, but I would say point 2. is something to argue.
You say its “desirable”, but the question is not explicitly ask about restrictions. The Order Makes the restored database available only to the members of db_owner, dbcreator, or sysadmin. If you there is a custom admingroup or something, you could have problems accessing the DB. So I would let it unchecked in this szenario!