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 on
a different machine. How can I restore these databases?
Help...
BrianWhat problems are you experiencing? "Major problems" isnt a lot to go on. See
Restore in BOL.
--
TIA,
ChrisR
"Brian Shafer" wrote:
> 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 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 started
in single user mode, it just hangs there?
Brian
"ChrisR" wrote:
> What problems are you experiencing? "Major problems" isnt a lot to go on. See
> Restore in BOL.
> --
> TIA,
> ChrisR
>
> "Brian Shafer" wrote:
> > 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 on
> > a different machine. How can I restore these databases?
> > Help...
> > Brian|||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:
> 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 started
> in single user mode, it just hangs there?
> Brian
> "ChrisR" wrote:
> > What problems are you experiencing? "Major problems" isnt a lot to go on. See
> > Restore in BOL.
> > --
> > TIA,
> > ChrisR
> >
> >
> > "Brian Shafer" wrote:
> >
> > > 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 on
> > > a different machine. How can I restore these databases?
> > > Help...
> > > Brian|||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...
> 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:
>> 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
>> started
>> in single user mode, it just hangs there?
>> Brian
>> "ChrisR" wrote:
>> > What problems are you experiencing? "Major problems" isnt a lot to go
>> > on. See
>> > Restore in BOL.
>> > --
>> > TIA,
>> > ChrisR
>> >
>> >
>> > "Brian Shafer" wrote:
>> >
>> > > 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 on
>> > > a different machine. How can I restore these databases?
>> > > Help...
>> > > Brian