Startup master in single user mode

[WinniePooh]

I am attempting to start my master database in single user mode using sqlservr -c -m. After 40 mins the command is still running. Is this correct or should it be instantaneous?

 

[SQLBill]

Yes.

If no one but you is logged in to the Master db, then it's quick. If there are other's logged in/using Master db (ie system stored procedures running) then it can take a while. Those users/whatever have to disconnect/stop running.

Did you use the command to make it immediate? (which isn't always a good thing).

-SQLBill

 

[WinniePooh]

The -c option will make it a faster shutdown (as far as I'm aware.) I've also tried it without this option and it still hangs at the point "SQL global counter collection task is created".

I have run the command after shutting down the SQL services so there shouldn't be any processes running at all.

 

[SQLBill]

I 'believe' the services still have to be running to put MASTER in single user mode.

-SQLBill

 

[WinniePooh]

I originally attempted to run the sqlservr command while the services were running but the command errored complaining that the errorlog file could not be found. Shutting down the services and running the command again resolved this error.

I have since managed to put SQL server into single user mode using Enterprise Manager. I'm using Sql2000. Right clicking on the servername and selecting properties and startup parameters gave me the opportunity to add a -m parameter.

Thanks for your suggestions.