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 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...
> 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 the default instance of SQL Server in single-user mode (Command
Prompt)
http://msdn.microsoft.com/library/de...tartp_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/de...tartp_5609.asp
AMB
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> How to start the default instance of SQL Server in single-user mode (Command
> Prompt)
> http://msdn.microsoft.com/library/de...tartp_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/de...tartp_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 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...
> 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...
>