How to Restart SQL Server in Single-User Mode ?

There are a couple of ways to start SQL Server in single-user mode..

  • You can start an instance of SQL Server in single-user mode by using the startup option –m
  • You can use -m option with sqlcmd or Management Studio
  • You can also start sqlservr.exe with –m option


You May Interest

What is Deadlock in SQL Server ?

Showing Server Active Server Name in MS SQL

Finding Server Default Language in MS SQL

What are the Authentication Modes in SQL Server ?

What are Replication and Database Mirroring in SQL Server ?