Starting SQL Server in single-user mode
This procedure describes
how to start SQL Server in single-user mode.
Note:
|
The
SQL Agent automatically puts the database in single-user mode for
restores of non-clustered databases that are the version SQL Server
2000 or higher. You need to start SQL Server in single-user mode
only if SQL Server is configured in a cluster.
|
To start SQL Server in single-user mode
-
In the Windows Control
Panel, open .
-
Select the MSSQLServer
service.
-
Type the following in the
Startup Parameters box:
/m
-
Click .