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.)
@see http://www.mssqltips.com/sqlservertutorial/110/how-to-restore-a-sql-server-backup/
So, restricted user is not checked?
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.
Slazenjer_m is almost right.
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!
The proposed answer makes no sense. The recovery mode of this database is SIMPLE as stated in the question, so there are NO “extra” transaction logs to restore. I believe this should be WITH RECOVERY.
https://msdn.microsoft.com/en-us/library/ms175510.aspx
I absolutely agree with ADM-Brazil’s approach: the SIMPLE recovery model does not allow any Transaction-Log backup
but it allows for differential one so the correct answer is norecovery