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

Ragnar

Is 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)
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)
http://msdn.microsoft.com/library/d... />
p_5609.asp


AMB

"Alejandro Mesa" wrote:

> How to start the default instance of SQL Server in single-user mode (Comma
nd
> Prompt)
> 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:
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@hotmai
l.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@hotmai
l.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@hotmai
l.nomail.com> wrote
> in message news:eV1vXHAUFHA.612@TK2MSFTNGP12.phx.gbl... 
>
>