5.8

Procedure
1. Click Start and select Administrative Tools > Services.
2. To put the SQL Server in single-user mode, right-click the SQLServer (MSSQLSERVER) service and
click Stop.
If the process prompts you to stop other services, such as the SQLServer Agent, click Yes.
3. Open a command window and type the following command to start the SQL Server service in single-
user mode.
NET START MSSQLSERVER /c /m
Wait for the service to start successfully.
4. Start SQL Server Management Studio and log in with the local SQL account.
To avoid opening the Object Explorer, when SQL Server Management Studio prompts you for login
credentials, click Cancel.
5. Click New Query to start a new query definition.
6. In the query window, type the following commands to restore the master database from backup.
USE MASTER
GO
RESTORE DATABASE [master]
FROM DISK = N'E:\MSSQL\Backup\master\master_backup_201003021337.bak
VCM Backup and Disaster Recovery Guide
34
VMware, Inc.