How to start SQL Server in single-user mode

Restoring master database requires the SQL Server running in single user mode. To start SQL Server in single user mode :

Open "Control Panel->Administrative Tools->Services"
Mouse right click on specified SQL Server instance service and select "Properties" menu to bring up following configuration window:
Specify start parameters as following:

-s{ Instance name } -m

If instance is default instance (no instance name) ,then just enter

-s -m
Restart the SQL Server instance service

SQL Server Backup enables you restore master database more easy . Just Click here to learn more.

Welcome