SQL single user mode

[AnnDroyd]

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?

Edited May 2, 2008 by AnnDroyd

[Jona]

http://www.cryer.co.uk/brian/sqlserver/howto_start_single_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?