How to start the default instance of SQL Server in single-user mode (Command Prompt)

How to Install SQL Server 2000

How To

How to start the default instance of SQL Server in single-user mode (Command Prompt)

To start the default instance of SQL Server in single-user mode from a command prompt

  • From a command prompt, enter:

    sqlservr.exe -c -m

    Note  You must switch to the appropriate directory (for the instance of Microsoft® SQL Server™ you want to start) in the command window before starting sqlservr.exe.

See Also

Starting SQL Server in Single-User Mode

Using Startup Options