Refer to the following instructions to restore the master database:
- Stop the SQL instance.
- Restart the SQL instance in single-user mode.
From a command prompt, browse to the appropriate directory for the instance of SQL to start
Enter the following command.
For default instance >sqlservr.exe -c -m For named instance >sqlservr.exe -c -m {instance_name}Important: Only perform Step 1 and 2 if you are restoring the master database.
- Open SQL Server Enterprise Manager; connect to the server where the backup is to be restored.
- Right click the master 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.
- Click the Options tab and select appropriate options for the restore operation.
- Click OK in the Restore Database dialog box to begin the restore process.
- Restart the SQL instance in multi-user mode afterward.
Restart the SQL Windows services, or enter the following command.
For default instance >sqlservr.exe -c For named instance >sqlservr.exe -c {instance_name} - Continue with the following steps to restore other system database and the user databases.
If the file exists on a network share, provide the UNC share name in the File name text box.
