Archive for the ‘Start SQL Server Service in Single-User Mode’ Category

Start SQL Server Service in Single-User Mode

May 1, 2010 Leave a comment

Under certain circumstances, 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:

  • Only one user can connect to the server.
  • The CHECKPOINT process is not executed. By default, it is executed automatically at startup.