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.)

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.)

Answer:



Leave a Reply 7

Your email address will not be published. Required fields are marked *


Ricardo

Ricardo

So, restricted user is not checked?

Slazenjer_m

Slazenjer_m

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.

JosefTheGreat

JosefTheGreat

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!

ADM-Brazil

ADM-Brazil

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

jar_2007

jar_2007

I absolutely agree with ADM-Brazil’s approach: the SIMPLE recovery model does not allow any Transaction-Log backup

Dan

Dan

but it allows for differential one so the correct answer is norecovery