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