SQL single user mode

[jwood]

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?

[Jona]

http://www.cryer.co.uk/brian/sqlserv..._user_mode.htm Any help?

[Jona]

Well assuming that tutorial is correct stop SQL server process then go

start > run > C:\Program Files\Microsoft SQL Server\MSSQL\BINN\sqlservr -m

??

[Iain]

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?