Problems with restoring master from a backup - SQL Server 2000

Hello,
I am trying to restore the master DB and I am not getting anywhere.
I stor the server, then restart it in single user mode (sqlservr.exe -c -m
from command prompt)
When I open Enterprise Manager I find that my user DB is in single user
mode, master is not, so when I try to restore I get a message that master
must be in single user mode.
I must be missing something.
Anu help would be appreciated
RagnarIs this a default or a named instance? If it is a named instance, you need t
o use the I switch as
well (I think it is "I", but you better check with BIL, might be "i").
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Ragnar Midtskogen" <ragnar_ng@.newsgroups.com> wrote in message
news:%23Oz%23yXzTFHA.3952@.TK2MSFTNGP15.phx.gbl...
> Hello,
> I am trying to restore the master DB and I am not getting anywhere.
> I stor the server, then restart it in single user mode (sqlservr.exe -c -m
from command prompt)
> When I open Enterprise Manager I find that my user DB is in single user mo
de, master is not, so
> when I try to restore I get a message that master must be in single user m
ode.
> I must be missing something.
> Anu help would be appreciated
> Ragnar
>|||How to start the default instance of SQL Server in single-user mode (Command
Prompt)
p_4okl.asp" target="_blank">http://msdn.microsoft.com/library/d... />
p_4okl.asp
AMB
"Ragnar Midtskogen" wrote:

> Hello,
> I am trying to restore the master DB and I am not getting anywhere.
> I stor the server, then restart it in single user mode (sqlservr.exe -c -m
> from command prompt)
> When I open Enterprise Manager I find that my user DB is in single user
> mode, master is not, so when I try to restore I get a message that master
> must be in single user mode.
> I must be missing something.
> Anu help would be appreciated
> Ragnar
>
>|||How to start a named instance of SQL Server in single-user mode (Command
Prompt)
p_5609.asp" target="_blank">http://msdn.microsoft.com/library/d... />
p_5609.asp
AMB
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> How to start the default instance of SQL Server in single-user mode (Comma
nd
> Prompt)
> rtp_4okl.asp" target="_blank">http://msdn.microsoft.com/library/d...>
rtp_4okl.asp
>
> AMB
> "Ragnar Midtskogen" wrote:
>|||Thank you Tibor,
I did not install it, but as far as I can tell it is a default instance.
For example, the name of the processes are MSSQLServer and SQLServerAgent.
Ragnar|||Thank you Alejandro,
As I wrote in my post:
> I stop the server, then restart it in single user mode (sqlservr.exe -c -m
> from command prompt)
This is what is described in the link:
p_4okl.asp" target="_blank">http://msdn.microsoft.com/library/d... />
p_4okl.asp
Ragnar|||FYI. for a named instance the syntax is:
a.. From a command prompt, enter:
sqlservr.exe -c - m -s {instancename}
Ragnar
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OQVhbdzTFHA.2556@.TK2MSFTNGP12.phx.gbl...
> Is this a default or a named instance? If it is a named instance, you need
> to use the I switch as well (I think it is "I", but you better check with
> BIL, might be "i").
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Ragnar Midtskogen" <ragnar_ng@.newsgroups.com> wrote in message
> news:%23Oz%23yXzTFHA.3952@.TK2MSFTNGP15.phx.gbl...
>|||Try using Query Analyzer instead of EM to do the restore. post the RESTORE D
ATABASE command you
execute and the exact error message from SQL Server.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Ragnar Midtskogen" <ragnar_ng@.newsgroups.com> wrote in message
news:OsCB76$TFHA.3436@.TK2MSFTNGP09.phx.gbl...
> Thank you Tibor,
> I did not install it, but as far as I can tell it is a default instance.
> For example, the name of the processes are MSSQLServer and SQLServerAgent.
> Ragnar
>|||Thanks Tibor,
The error message I get no matter which way I do the restore is that the
master DB must be in single user mode.
The problem here is that even though I follow the recommended procedure for
starting the server in single user mode just puts my user DB in single user
mode.
I did a test and confirmed that my user DB was in single user moed and it
was.
However, I found a post on a NG where someone had the same problem and he
solved it by setting a property in SQL Server to start in single user mode
and it worked for him.
Problem is I can't find the property, and this was post from a couple of
years ago so there is no way to get in touch with the guy.
I will do some more searching when I get a chance.
Ragnar
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:eV1vXHAUFHA.612@.TK2MSFTNGP12.phx.gbl...
> Try using Query Analyzer instead of EM to do the restore. post the RESTORE
> DATABASE command you execute and the exact error message from SQL Server.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Ragnar Midtskogen" <ragnar_ng@.newsgroups.com> wrote in message
> news:OsCB76$TFHA.3436@.TK2MSFTNGP09.phx.gbl...
>|||To start the SQL Server in single user mode for master or any other system
database recovery
From the command prompt
sqlservr.exe -m
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Ragnar Midtskogen" <ragnar_ng@.newsgroups.com> wrote in message
news:uX0RF6aUFHA.2664@.TK2MSFTNGP15.phx.gbl...
> Thanks Tibor,
> The error message I get no matter which way I do the restore is that the
> master DB must be in single user mode.
> The problem here is that even though I follow the recommended procedure
> for starting the server in single user mode just puts my user DB in single
> user mode.
> I did a test and confirmed that my user DB was in single user moed and it
> was.
> However, I found a post on a NG where someone had the same problem and he
> solved it by setting a property in SQL Server to start in single user mode
> and it worked for him.
> Problem is I can't find the property, and this was post from a couple of
> years ago so there is no way to get in touch with the guy.
> I will do some more searching when I get a chance.
> Ragnar
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> in message news:eV1vXHAUFHA.612@.TK2MSFTNGP12.phx.gbl...
>