restore master database

I have two instances on a sql2000 server. I need to change master database to
single user mode,
so I can restore the master database from a different server.
I tried the command line, and queries. none of them worked.
ThanksDid you try?
sqlservr -m
Why do you want to restore the master database from a different server?
Ben Nevarez, MCDBA, OCP
Database Administrator
"anoni" wrote:
> I have two instances on a sql2000 server. I need to change master database to
> single user mode,
> so I can restore the master database from a different server.
> I tried the command line, and queries. none of them worked.
> Thanks|||I did.
I need to have production master database to restored on testing sql server
master database.
"Ben Nevarez" wrote:
> Did you try?
> sqlservr -m
> Why do you want to restore the master database from a different server?
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "anoni" wrote:
> > I have two instances on a sql2000 server. I need to change master database to
> > single user mode,
> > so I can restore the master database from a different server.
> >
> > I tried the command line, and queries. none of them worked.
> >
> > Thanks|||It is not master the one that needs to be in single user mode but the entire
SQL Server instance. Stop SQL Server and run
sqlservr -m
If you have errors let us know.
Ben Nevarez, MCDBA, OCP
Database Administrator
"anoni" wrote:
> I did.
> I need to have production master database to restored on testing sql server
> master database.
> "Ben Nevarez" wrote:
> >
> > Did you try?
> >
> > sqlservr -m
> >
> > Why do you want to restore the master database from a different server?
> >
> > Ben Nevarez, MCDBA, OCP
> > Database Administrator
> >
> >
> > "anoni" wrote:
> >
> > > I have two instances on a sql2000 server. I need to change master database to
> > > single user mode,
> > > so I can restore the master database from a different server.
> > >
> > > I tried the command line, and queries. none of them worked.
> > >
> > > Thanks|||I did try the command.
it stop at Recover complete then showed prompt(at next line). sql service
never started.
"Ben Nevarez" wrote:
> It is not master the one that needs to be in single user mode but the entire
> SQL Server instance. Stop SQL Server and run
> sqlservr -m
> If you have errors let us know.
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "anoni" wrote:
> > I did.
> > I need to have production master database to restored on testing sql server
> > master database.
> >
> > "Ben Nevarez" wrote:
> >
> > >
> > > Did you try?
> > >
> > > sqlservr -m
> > >
> > > Why do you want to restore the master database from a different server?
> > >
> > > Ben Nevarez, MCDBA, OCP
> > > Database Administrator
> > >
> > >
> > > "anoni" wrote:
> > >
> > > > I have two instances on a sql2000 server. I need to change master database to
> > > > single user mode,
> > > > so I can restore the master database from a different server.
> > > >
> > > > I tried the command line, and queries. none of them worked.
> > > >
> > > > Thanks|||how do you restore database while sql is not running?
"Ben Nevarez" wrote:
> It is not master the one that needs to be in single user mode but the entire
> SQL Server instance. Stop SQL Server and run
> sqlservr -m
> If you have errors let us know.
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "anoni" wrote:
> > I did.
> > I need to have production master database to restored on testing sql server
> > master database.
> >
> > "Ben Nevarez" wrote:
> >
> > >
> > > Did you try?
> > >
> > > sqlservr -m
> > >
> > > Why do you want to restore the master database from a different server?
> > >
> > > Ben Nevarez, MCDBA, OCP
> > > Database Administrator
> > >
> > >
> > > "anoni" wrote:
> > >
> > > > I have two instances on a sql2000 server. I need to change master database to
> > > > single user mode,
> > > > so I can restore the master database from a different server.
> > > >
> > > > I tried the command line, and queries. none of them worked.
> > > >
> > > > Thanks|||When you use
sqlservr -m
do you see
SQL Server started in single user mode. Updates ...
on the screen or on the SQL Server log? (It is on line 10 on my test
instalation.)
Do you see any error?
Ben Nevarez, MCDBA, OCP
Database Administrator
"anoni" wrote:
> I did try the command.
> it stop at Recover complete then showed prompt(at next line). sql service
> never started.
> "Ben Nevarez" wrote:
> >
> > It is not master the one that needs to be in single user mode but the entire
> > SQL Server instance. Stop SQL Server and run
> >
> > sqlservr -m
> >
> > If you have errors let us know.
> >
> > Ben Nevarez, MCDBA, OCP
> > Database Administrator
> >
> >
> > "anoni" wrote:
> >
> > > I did.
> > > I need to have production master database to restored on testing sql server
> > > master database.
> > >
> > > "Ben Nevarez" wrote:
> > >
> > > >
> > > > Did you try?
> > > >
> > > > sqlservr -m
> > > >
> > > > Why do you want to restore the master database from a different server?
> > > >
> > > > Ben Nevarez, MCDBA, OCP
> > > > Database Administrator
> > > >
> > > >
> > > > "anoni" wrote:
> > > >
> > > > > I have two instances on a sql2000 server. I need to change master database to
> > > > > single user mode,
> > > > > so I can restore the master database from a different server.
> > > > >
> > > > > I tried the command line, and queries. none of them worked.
> > > > >
> > > > > Thanks|||I do see the message. But how do i recover the database since the sql service
is not running from enterprise mgr
"Ben Nevarez" wrote:
> When you use
> sqlservr -m
> do you see
> SQL Server started in single user mode. Updates ...
> on the screen or on the SQL Server log? (It is on line 10 on my test
> instalation.)
> Do you see any error?
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "anoni" wrote:
> > I did try the command.
> > it stop at Recover complete then showed prompt(at next line). sql service
> > never started.
> >
> > "Ben Nevarez" wrote:
> >
> > >
> > > It is not master the one that needs to be in single user mode but the entire
> > > SQL Server instance. Stop SQL Server and run
> > >
> > > sqlservr -m
> > >
> > > If you have errors let us know.
> > >
> > > Ben Nevarez, MCDBA, OCP
> > > Database Administrator
> > >
> > >
> > > "anoni" wrote:
> > >
> > > > I did.
> > > > I need to have production master database to restored on testing sql server
> > > > master database.
> > > >
> > > > "Ben Nevarez" wrote:
> > > >
> > > > >
> > > > > Did you try?
> > > > >
> > > > > sqlservr -m
> > > > >
> > > > > Why do you want to restore the master database from a different server?
> > > > >
> > > > > Ben Nevarez, MCDBA, OCP
> > > > > Database Administrator
> > > > >
> > > > >
> > > > > "anoni" wrote:
> > > > >
> > > > > > I have two instances on a sql2000 server. I need to change master database to
> > > > > > single user mode,
> > > > > > so I can restore the master database from a different server.
> > > > > >
> > > > > > I tried the command line, and queries. none of them worked.
> > > > > >
> > > > > > Thanks|||You need SQL Server running in single user admin mode. Is that a default
instance?
Try sqlservr -m again and copy/paste the text output here.
Ben Nevarez, MCDBA, OCP
Database Administrator
"anoni" wrote:
> how do you restore database while sql is not running?
> "Ben Nevarez" wrote:
> >
> > It is not master the one that needs to be in single user mode but the entire
> > SQL Server instance. Stop SQL Server and run
> >
> > sqlservr -m
> >
> > If you have errors let us know.
> >
> > Ben Nevarez, MCDBA, OCP
> > Database Administrator
> >
> >
> > "anoni" wrote:
> >
> > > I did.
> > > I need to have production master database to restored on testing sql server
> > > master database.
> > >
> > > "Ben Nevarez" wrote:
> > >
> > > >
> > > > Did you try?
> > > >
> > > > sqlservr -m
> > > >
> > > > Why do you want to restore the master database from a different server?
> > > >
> > > > Ben Nevarez, MCDBA, OCP
> > > > Database Administrator
> > > >
> > > >
> > > > "anoni" wrote:
> > > >
> > > > > I have two instances on a sql2000 server. I need to change master database to
> > > > > single user mode,
> > > > > so I can restore the master database from a different server.
> > > > >
> > > > > I tried the command line, and queries. none of them worked.
> > > > >
> > > > > Thanks|||after ran the sqlservr -m, sql is running in single user mode. But from the
Enterprise mgr. it shows sql is stopped.
I do I restore the master database after I sql running in single user mode
since I can not restore it from the Enterprise mgr?
"Ben Nevarez" wrote:
> You need SQL Server running in single user admin mode. Is that a default
> instance?
> Try sqlservr -m again and copy/paste the text output here.
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "anoni" wrote:
> > how do you restore database while sql is not running?
> >
> > "Ben Nevarez" wrote:
> >
> > >
> > > It is not master the one that needs to be in single user mode but the entire
> > > SQL Server instance. Stop SQL Server and run
> > >
> > > sqlservr -m
> > >
> > > If you have errors let us know.
> > >
> > > Ben Nevarez, MCDBA, OCP
> > > Database Administrator
> > >
> > >
> > > "anoni" wrote:
> > >
> > > > I did.
> > > > I need to have production master database to restored on testing sql server
> > > > master database.
> > > >
> > > > "Ben Nevarez" wrote:
> > > >
> > > > >
> > > > > Did you try?
> > > > >
> > > > > sqlservr -m
> > > > >
> > > > > Why do you want to restore the master database from a different server?
> > > > >
> > > > > Ben Nevarez, MCDBA, OCP
> > > > > Database Administrator
> > > > >
> > > > >
> > > > > "anoni" wrote:
> > > > >
> > > > > > I have two instances on a sql2000 server. I need to change master database to
> > > > > > single user mode,
> > > > > > so I can restore the master database from a different server.
> > > > > >
> > > > > > I tried the command line, and queries. none of them worked.
> > > > > >
> > > > > > Thanks|||no. it is not the default instance. it is the second instance that i created.
The default is ok. I could not restore the second instance.
"Ben Nevarez" wrote:
> You need SQL Server running in single user admin mode. Is that a default
> instance?
> Try sqlservr -m again and copy/paste the text output here.
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "anoni" wrote:
> > how do you restore database while sql is not running?
> >
> > "Ben Nevarez" wrote:
> >
> > >
> > > It is not master the one that needs to be in single user mode but the entire
> > > SQL Server instance. Stop SQL Server and run
> > >
> > > sqlservr -m
> > >
> > > If you have errors let us know.
> > >
> > > Ben Nevarez, MCDBA, OCP
> > > Database Administrator
> > >
> > >
> > > "anoni" wrote:
> > >
> > > > I did.
> > > > I need to have production master database to restored on testing sql server
> > > > master database.
> > > >
> > > > "Ben Nevarez" wrote:
> > > >
> > > > >
> > > > > Did you try?
> > > > >
> > > > > sqlservr -m
> > > > >
> > > > > Why do you want to restore the master database from a different server?
> > > > >
> > > > > Ben Nevarez, MCDBA, OCP
> > > > > Database Administrator
> > > > >
> > > > >
> > > > > "anoni" wrote:
> > > > >
> > > > > > I have two instances on a sql2000 server. I need to change master database to
> > > > > > single user mode,
> > > > > > so I can restore the master database from a different server.
> > > > > >
> > > > > > I tried the command line, and queries. none of them worked.
> > > > > >
> > > > > > Thanks|||When SQL Server is running in single user admin mode onle one admin session
can connect using Enterprise Manager or Query Analyzer. I have seen that EM
shows like the instance is down (red square) but I can still do right-click
and select Connect.
Ben Nevarez
"anoni" wrote:
> after ran the sqlservr -m, sql is running in single user mode. But from the
> Enterprise mgr. it shows sql is stopped.
> I do I restore the master database after I sql running in single user mode
> since I can not restore it from the Enterprise mgr?
> "Ben Nevarez" wrote:
> >
> > You need SQL Server running in single user admin mode. Is that a default
> > instance?
> >
> > Try sqlservr -m again and copy/paste the text output here.
> >
> > Ben Nevarez, MCDBA, OCP
> > Database Administrator
> >
> >
> > "anoni" wrote:
> >
> > > how do you restore database while sql is not running?
> > >
> > > "Ben Nevarez" wrote:
> > >
> > > >
> > > > It is not master the one that needs to be in single user mode but the entire
> > > > SQL Server instance. Stop SQL Server and run
> > > >
> > > > sqlservr -m
> > > >
> > > > If you have errors let us know.
> > > >
> > > > Ben Nevarez, MCDBA, OCP
> > > > Database Administrator
> > > >
> > > >
> > > > "anoni" wrote:
> > > >
> > > > > I did.
> > > > > I need to have production master database to restored on testing sql server
> > > > > master database.
> > > > >
> > > > > "Ben Nevarez" wrote:
> > > > >
> > > > > >
> > > > > > Did you try?
> > > > > >
> > > > > > sqlservr -m
> > > > > >
> > > > > > Why do you want to restore the master database from a different server?
> > > > > >
> > > > > > Ben Nevarez, MCDBA, OCP
> > > > > > Database Administrator
> > > > > >
> > > > > >
> > > > > > "anoni" wrote:
> > > > > >
> > > > > > > I have two instances on a sql2000 server. I need to change master database to
> > > > > > > single user mode,
> > > > > > > so I can restore the master database from a different server.
> > > > > > >
> > > > > > > I tried the command line, and queries. none of them worked.
> > > > > > >
> > > > > > > Thanks|||Yes, EM doesn't understand the SQL Server is started as it is started in a special way...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
news:F5D9C15E-FE3C-4A5B-B001-988626F761DF@.microsoft.com...
> When SQL Server is running in single user admin mode onle one admin session
> can connect using Enterprise Manager or Query Analyzer. I have seen that EM
> shows like the instance is down (red square) but I can still do right-click
> and select Connect.
> Ben Nevarez
>
> "anoni" wrote:
>> after ran the sqlservr -m, sql is running in single user mode. But from the
>> Enterprise mgr. it shows sql is stopped.
>> I do I restore the master database after I sql running in single user mode
>> since I can not restore it from the Enterprise mgr?
>> "Ben Nevarez" wrote:
>> >
>> > You need SQL Server running in single user admin mode. Is that a default
>> > instance?
>> >
>> > Try sqlservr -m again and copy/paste the text output here.
>> >
>> > Ben Nevarez, MCDBA, OCP
>> > Database Administrator
>> >
>> >
>> > "anoni" wrote:
>> >
>> > > how do you restore database while sql is not running?
>> > >
>> > > "Ben Nevarez" wrote:
>> > >
>> > > >
>> > > > It is not master the one that needs to be in single user mode but the entire
>> > > > SQL Server instance. Stop SQL Server and run
>> > > >
>> > > > sqlservr -m
>> > > >
>> > > > If you have errors let us know.
>> > > >
>> > > > Ben Nevarez, MCDBA, OCP
>> > > > Database Administrator
>> > > >
>> > > >
>> > > > "anoni" wrote:
>> > > >
>> > > > > I did.
>> > > > > I need to have production master database to restored on testing sql server
>> > > > > master database.
>> > > > >
>> > > > > "Ben Nevarez" wrote:
>> > > > >
>> > > > > >
>> > > > > > Did you try?
>> > > > > >
>> > > > > > sqlservr -m
>> > > > > >
>> > > > > > Why do you want to restore the master database from a different server?
>> > > > > >
>> > > > > > Ben Nevarez, MCDBA, OCP
>> > > > > > Database Administrator
>> > > > > >
>> > > > > >
>> > > > > > "anoni" wrote:
>> > > > > >
>> > > > > > > I have two instances on a sql2000 server. I need to change master database to
>> > > > > > > single user mode,
>> > > > > > > so I can restore the master database from a different server.
>> > > > > > >
>> > > > > > > I tried the command line, and queries. none of them worked.
>> > > > > > >
>> > > > > > > Thanks