How to recover master database

How Do I do to recover information from master database
to master database?Lorena
if you mean copy between master in one installation and master in =
another you could use DTS, linked servers or a variety of other options, =
but it all depneds what you are trying to recover from where and to =
where, can you post some more details?
Mike John
"Lorena" <anonymous@.discussions.microsoft.com> wrote in message =
news:d71701c40de3$4f81cb20$a601280a@.phx.gbl...
> How Do I do to recover information from master database
> to master database?
>|||My database master was destroided, but I have a full
backup of master database, but i can't recover it, show
me the next message. RESTORE DATABASE must be used in
single user mode when trying to restore the master
database
I need recover information about the aplicactions users.
Thanks
Lorena

>--Original Message--
>Lorena
>if you mean copy between master in one installation and
master in another you could use DTS, linked servers or a
variety of other options, but it all depneds what you are
trying to recover from where and to where, can you post
some more details?
>Mike John
>"Lorena" <anonymous@.discussions.microsoft.com> wrote in
message news:d71701c40de3$4f81cb20$a601280a@.phx.gbl...
>.
>|||If you search for below in Books Online, you find instructions on how to
start SQL Server in single user mode:
"restore master"
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Lorena" <anonymous@.discussions.microsoft.com> wrote in message
news:bb8d01c40de8$f50d2670$a001280a@.phx.gbl...
> My database master was destroided, but I have a full
> backup of master database, but i can't recover it, show
> me the next message. RESTORE DATABASE must be used in
> single user mode when trying to restore the master
> database
> I need recover information about the aplicactions users.
> Thanks
> Lorena
>
>
> master in another you could use DTS, linked servers or a
> variety of other options, but it all depneds what you are
> trying to recover from where and to where, can you post
> some more details?
> message news:d71701c40de3$4f81cb20$a601280a@.phx.gbl...|||Hi,
Steps:
1. Stop MSSQL server Service from Control panel
2. Execute sqlservr.exe -c -m from command prompt
3. Restore the Master database backup using RESTORE DATABASE
4. Once all the activies are over Press COntrol break in key board to stop
MS Sqlserver
5. Restart SQL server from COntrol panel services as normal.
Consider the below after master restore
a. If the Master backup is old, then any database users previously
associated with logins that need to be re-created .
b. If any user databases were created after Master db was backed up, those
databases will not be available.Use SP_Attach_db to
attach those databases to avoid restore time. If attach gives issues
then try restoring from backup.
Thanks
Hari
MCDBA
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ezAvumeDEHA.2932@.tk2msftngp13.phx.gbl...
> If you search for below in Books Online, you find instructions on how to
> start SQL Server in single user mode:
> "restore master"
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "Lorena" <anonymous@.discussions.microsoft.com> wrote in message
> news:bb8d01c40de8$f50d2670$a001280a@.phx.gbl...
>