Step 4. Specify Restore Target
At the Target step of the wizard, specify where and how you want to restore the database:
- From the Instance drop-down list, select the Microsoft SQL Server instance where you want to restore the database.
- In the Database field, specify the name for the restored database or select the name of the target database from the drop-down list. Keep in mind that if you restore a database from the backup to a database that exists in the Microsoft SQL Server instance, the target database will be overwritten.
- In the Recovery state section, select the recovery state:
- RECOVERY
Rolls back (undo) any uncommitted changes.
- NORECOVERY
Skips the undo phase so that uncommitted or incomplete transactions are held open.
This allows further restore stages to carry on from the restore point. When applying this option, the database will be in the norecovery state and inaccessible to users.
- STANDBY
The database will be in the standby state and therefore available for read operations. You can also provide a standby file with uncommitted transactions.
For more information on recovery modes, see this Microsoft article.
- Specify the following file locations:
- Primary database file
- Secondary database file and log files
To specify file locations, do the following:
- Click Browse next to the necessary database file type.
- In the Browse For Folder window, browse to the folder where you want to create the restored database files or click Make New Folder to create a new folder, and click OK.
- Click Run to start the restore process.
