Very Computer

Trying to restore the master  and it says "db should be in
single user mode" .
I tried starting with

    Net start MSSQLSERVER -m
but does not seem to help . what else do I need to make it
work .
Thanks

When restoring master, SQL Server needs to be started in single-user mode
to prevent any additional users from using SQL Server. All SQL Server
services (except SQL Server itself) and utilities, such as the SQL Server
Agent, can be stopped because they may try to access SQL Server.

To start the default instance of SQL Server in single-user mode from a
command prompt

From a command prompt, enter:
sqlservr.exe -c -m

Note : You must switch to the appropriate directory (for the instance of
Microsoft? SQL Server you want to start) in the command window before
starting sqlservr.exe.

To start a named instance of SQL Server in single-user mode from a command
prompt

From a command prompt, enter:
sqlservr.exe -c - m -s {instancename}

For more information refer

Restoring the master Database from a Current Backup
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/admi...
_bkprst_4g4w.asp

Backing Up and Restoring Databases
http://www.microsoft.com/technet/treeview/default.asp?url=/TechNet/pr...
ol/sql/proddocs/admincmp/75517c03.asp

Regards,

Uttam.

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure?  For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.

Alfred,

Start SQL Server in single-user mode by entering sqlservr.exe -c -m in a
commnd prompt.

The process is mentioned in
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q304692

Dinesh.
--
---
SQL Server FAQ at
www.tkdinesh.com

Quote:> Trying to restore the master  and it says "db should be in
> single user mode" .
> I tried starting with

>     Net start MSSQLSERVER -m
> but does not seem to help . what else do I need to make it
> work .
> Thanks

Thanks it worked , didn't realise I had to use -c alongwith

Quote:>-----Original Message-----
>Alfred,

>Start SQL Server in single-user mode by entering

sqlservr.exe -c -m in a