Starting SQL Server in Single-User Mode - TechNet Articles - United States (English) - TechNet Wiki

For some actions you may have to start an instance of Microsoft SQL Server in single-user mode by using the startup option  -m.

For example, you may want to change server configuration options or recover a damaged master database or other system database. Both actions require starting an instance of SQL Server in single-user mode.

When you start an instance of SQL Server in single-user mode, note the following:

Note: 
Stop the SQ3 fiji-r3">

Starting SQL Server in Single-User Mode

For some actions you may have to start an instance of Microsoft SQL Server in single-user mode by using the startup option  -m.

For example, you may want to change server configuraL Server Agent service before connecting to an instance of SQL Server in single-user mode; otherwise, the SQL Server Agent service uses the connection, thereby blocking it. 



See Also

Other Languages

This article is also available in the following languages: 

Japonês (ja-JP)

Brazilian Portuguese (pt-BR)