How to Restart SQL Server in Single-User Mode ?

173 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

MS SQL Show Only Date of Current Time

What is a Control Flow Inside SSIS ?

Adding Columns to a Table with a Query in MS SQL

Using MS SQL WHERE

What is CHECKPOINT Process in the SQL Server ?