How to Restart SQL Server in Single-User Mode ?

31 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 Restoring a Database With a Query

Generating Random Letters in MS SQL

Using MS SQL DISTINCT

Getting List of System Hard Disks with Free Space in MS SQL Serve ...

Getting List of MS SQL User-Created Tables