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.
Thanks
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.
I need to have production master database to restored on testing sql server
master database.
"Ben Nevarez" wrote:
[vbcol=seagreen]
> 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:
|||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:
[vbcol=seagreen]
> I did.
> I need to have production master database to restored on testing sql server
> master database.
> "Ben Nevarez" wrote:
|||I did try the command.
it stop at Recover complete then showed prompt(at next line). sql service
never started.
"Ben Nevarez" wrote:
[vbcol=seagreen]
> 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:
|||how do you restore database while sql is not running?
"Ben Nevarez" wrote:
[vbcol=seagreen]
> 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:
|||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:
[vbcol=seagreen]
> I did try the command.
> it stop at Recover complete then showed prompt(at next line). sql service
> never started.
> "Ben Nevarez" wrote:
|||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:
[vbcol=seagreen]
> 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:
|||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:
[vbcol=seagreen]
> how do you restore database while sql is not running?
> "Ben Nevarez" 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:
[vbcol=seagreen]
> 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: