Restoring Master and MSDB databases!

Hi,
I still have yet to find a way to restore these databases. To tell you what
I did.
I made a backup of the master, msdb and my user database and log file. I
can restore the user db and log file, but am have major problems with
restoring these to databases. I am restoring in a development envirorment o
n
a different machine. How can I restore these databases?
Help...
BrianWhat problems are you experiencing? "Major problems" isnt a lot to go on. Se
e
Restore in BOL.
--
TIA,
ChrisR
"Brian Shafer" wrote:

> Hi,
> I still have yet to find a way to restore these databases. To tell you wh
at
> I did.
> I made a backup of the master, msdb and my user database and log file. I
> can restore the user db and log file, but am have major problems with
> restoring these to databases. I am restoring in a development envirorment
on
> a different machine. How can I restore these databases?
> Help...
> Brian|||I had started a thread on called "Restoring a DB". The problem is it wants
me to put it in single user mode. Now from what I understand, I can only do
this through the command line. When I do this I can't seem to get it starte
d
in single user mode, it just hangs there?
Brian
"ChrisR" wrote:
[vbcol=seagreen]
> What problems are you experiencing? "Major problems" isnt a lot to go on.
See
> Restore in BOL.
> --
> TIA,
> ChrisR
>
> "Brian Shafer" wrote:
>|||the best way in your case will be using EM to add -m startup parameter then
restart MSDBand restore master first then msdb and user db . When done just
remove -m and restart MSDB. I hope this helps
"Brian Shafer" wrote:
[vbcol=seagreen]
> I had started a thread on called "Restoring a DB". The problem is it want
s
> me to put it in single user mode. Now from what I understand, I can only d
o
> this through the command line. When I do this I can't seem to get it star
ted
> in single user mode, it just hangs there?
> Brian
> "ChrisR" wrote:
>|||Also, I hope you are not expecting to get a prompt in the command window
after starting in Single user mode.
Change to the appropriate directory and then run
sqlservr -c -m
Sql server then starts up in single user mode with a blinking cursor (not a
prompt). You then need to connect to Sql server using Query Analyzer to do
your restore. Use CTRL+C to stop SQL server after your restore and then
restart normally to restore user databases.
HTH.
TJ
PS:
(Stop all apps or services that may attempt to grab the first connection
before QA).
"Eli Milkova" <EliMilkova@.discussions.microsoft.com> wrote in message
news:FB844EA4-B077-4BE5-A82A-EEDFAEA109FC@.microsoft.com...[vbcol=seagreen]
> the best way in your case will be using EM to add -m startup parameter
> then
> restart MSDBand restore master first then msdb and user db . When done
> just
> remove -m and restart MSDB. I hope this helps
> "Brian Shafer" wrote:
>