How to Restart SQL Server in Single-User Mode ?

190 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

How is Sqlcmd Different from Osql ?

Using MS SQL Order By

MS SQL List of Records in All Tables

What is the Difference Between UNION and UNION ALL in SQL Server ...

Deleting Table With Query in MS SQL