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

  1. In the Windows Control Panel, open Services.

  2. Select the MSSQLServer service.

  3. Type the following in the Startup Parameters box:

    /m

  4. Click Start.