I need to get my SQL server into single user mode so I can restore the master database.
I've read about the -m switch but this doesn't seem to work.
What's the easiest way of doing this? Can it be done via the SQL management studio?
Printable View
I need to get my SQL server into single user mode so I can restore the master database.
I've read about the -m switch but this doesn't seem to work.
What's the easiest way of doing this? Can it be done via the SQL management studio?
Well assuming that tutorial is correct stop SQL server process then go
start > run > C:\Program Files\Microsoft SQL Server\MSSQL\BINN\sqlservr -m
??
Or add the -m switch to the startup parameter list under the properties of the server in the management console, and then restart the server process?