Specifications

4.
5.
6.
Click .OK In the section, select the database to which you wish to restore, and inDestination for restore
the section, select the backup file you selected above in step :Select the backup sets to restore 3
In the left pane, click , and select the following:Options
In the section, select , and leave the other optionsRestore options Overwrite the existing database (WITH REPLACE)
unselected.
In the section, select Recovery state Leave the database non-operational, and do not roll back uncommited transactions.
:Additional transaction logs can be restored. (RESTORE WITH NORECOVERY)