Refer to the following instructions to restore a complete backup:
- Open SQL Server Enterprise Manager; connect to the server where the backup is to be restored.
- Right click the corresponding database and select [All Tasks], then select [Restore database].
- Select the [From device] radio button and [Select Devices].
- In the [Choose Restore Devices] dialog box, select the [Disk] radio button.
- Click the [Add] button to display the dialog box, enter the file name of the backup file (restored from the OBS) that is to be restored.
- Select the [Restore backup set] radio button, and [Database - complete].
- Click the Options tab 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.
If the file exists on a network share, provide the UNC share name in the File name text box.
For the [Recovery completion state] setting:
Important:
If this is the final backup to be restored, select - [Leave database operational.
No additional transaction logs can 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