How to Restart SQL Server in Single-User Mode ?

42 Reads Ms Sql

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
Ms Sql

You May Interest

What is the Difference Between Clustered and a Non-clustered Inde ...

What are the INTERSECT Operators in SQL Server ?

What is Extensible Key Management in SQL Server ?

What are the System Data Collection Sets Predefined Inside SQL Se ...

Making a MS SQL Offline Database Online