Refer to the following instructions to restore a complete backup:
- Open SQL Server Management Studio; connect to the server where the backup is to be restored.
- Expand [Databases]. Depending on the database, either selects a user database or expands [System Databases], and then selects a system database.
- Right click the database, point to [Tasks], clicks [Restore], and then click [Database].
- On the General page, the name of the restoring database appears in the [To database] list box. To create a new database, enter its name in the list box.
- Select [From device]; click the browse button to open the [Specify Backup] dialog box. Click [Add].
- Browse to the backup file (restored from the OBS) that is to be restored.
- After adding the complete database file to the [Backup location] list box, click [OK] to return to the General page.
- In the [Select the backup sets to restore] grid, select the backups to restore.
- Click the Options page and select appropriate options for the restore operation.
- To start the restore operation, click OK.
- Continue to the next section to restore differential or transaction log backup.
Note:
SQL Server databases may be backed up on one server and restored to another server.
If the target database does not exist on the server, right click on any database instead. A new database can be created while restoring the backup.
For the [Recovery state] setting:
Important:
If this is the final backup to be restored, select -
[Leave database ready to use by rolling back uncommitted transactions. Additional transaction logs cannot be restored]
If there are further differential or transaction log to be applied, selection one of the other two options for the Recovery completion state.
