Starting SQL Server in Single-User Mode

Under certain circumstances, you may need to start Microsoft® SQL Server™ in single-user mode. This is the startup option -m. For example, you may want to change server configuration options or recover a damaged master or other system database; both require starting SQL Server in single-user mode.

When you start SQL Server in single-user mode:

• Only one user can connect to the server.
• The CHECKPOINT process is not executed. By default, it is executed automatically at startup.
• The sp_configure system stored procedure allow updates option is enabled. By default, the allow updates option is disabled.

To start SQL Server in single-user mode

See Also