This section describes how to backup and restore Microsoft SQL Server with the OBM.
Refer to the following instructions to restore the master database:
- Stop the SQL instance.
- Restart the SQL instance in single-user mode.
- In SQL Server Configuration Manager, click [SQL Server Services].
- In the right pane, right-click SQL Server, and then click [Properties].
- On the Startup Parameters tab, type the parameter .m in the specify startup parameter box and click on [Add] and click on [OK]
- Restore the database engine afterward.
Important:
When you start SQL Server in single-user mode, first stop SQL Server Agent.
Otherwise, SQL Server Agent might connect first, preventing you from connecting as a second user.
- To restore a full database backup of master, use the following RESTORE DATABASE Transact-SQL statement:
>RESTORE DATABASE master FROM ${backup_device} WITH REPLACE
${backup_device} is the database file restored from the OBS:
C:\>sqlcmd
1>RESTORE DATABASE master FROM DISK = .C:\temp\master.bak. WITH REPLACE;
2>GO
- After master is restored, the instance of SQL Server shuts down and terminates the sqlcmd process.
- Before you restart the server instance, ensure to remove the single user startup parameter that you have added previously in Step 2.
- Restart the server instance and continue other recovery steps such as restoring other databases.
Back to top