MIS Systems Thread, SQL single user mode in Technical; I need to get my SQL server into single user mode so I can restore the master database.
I've read ...
21st January 2008, 11:48 AM #1
- Rep Power
SQL single user mode
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?
Last edited by AnnDroyd; 2nd May 2008 at 08:18 AM.
21st January 2008, 11:59 AM #2
21st January 2008, 12:18 PM #3
Well assuming that tutorial is correct stop SQL server process then go
start > run > C:\Program Files\Microsoft SQL Server\MSSQL\BINN\sqlservr -m
21st January 2008, 12:19 PM #4
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?
By siuko in forum How do you do....it?
Last Post: 20th June 2012, 11:29 AM
By ryan_powell in forum Scripts
Last Post: 4th June 2009, 02:43 PM
By philtomo-25 in forum How do you do....it?
Last Post: 15th November 2007, 09:21 PM
By cokecan72 in forum Windows
Last Post: 29th June 2007, 01:13 PM
By Uraken in forum Windows
Last Post: 18th May 2007, 12:29 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)