Starting SQL Server in Single-User Mode

  • Post author:
  • Post category:
  • Post comments:1 Comment
  • Post last modified:January 7, 2005

Under certain circumstances, you may need to start an instance of Microsoft® SQL Server™ in single-user mode 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:

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

From a command prompt, enter:

sqlservr.exe -c -m

 

This Post Has One Comment

  1. William Chung

    or u can use the following command since sql 2000:
    NET START MSSQLSERVER /m

    and i belive it’s better than
    sqlservr.exe /m

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.