Hey all, yet again...
I got a response, but am still having issues, and hoping someone could go
into a little more detail on this? I am having issues...
So far I have opened a cmd prompt open and got it started using -c -m...
Then, though EM, restore master DB...then it shuts down, and that is all the
further I could go. I cannot get it restarted...did I do something wrong?
Would it be better to do this from a command prompt or similar and not EM?
Please advise...
Cory Ellingson
Production Services
-----Original Message-----
From: bariq [mailto:[Email address protected]
Sent: Wednesday, March 30, 2005 11:43 PM
To: CORY.[Email address protected]
Subject: RE: Single User Mode
**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret
**from this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal
**Anything below this line is the original email text
1) Start SQL server in single user mode
2) Restore master database from the backup
3) restart sql server in normal mode
4) Restore MSDB database from the backup
5) Restore all other database from the backups
you are good to go. Remember if you are restoring in different drive and
directory use this syntax
Restore database <databasename> from disk='<d:xxyyoo.bak>' with recovery,
move '<mdf file name>' to '<new mdf location>',
move '<ldf file name>' to '<new ldf location>'
cheers
Bariq
Quoting "Ellingson Cory \(RCIS\)"
<mssqldba-ezmlmshield-x90928401.[Email address protected]
> Okay, little update. With a little guidance from Yousefi, I was able to
> start this up in single user mode. I restored my master, and now get a
> number of errors trying to restart the service.
>
> Instead of going into the details of the errors, I guess, I want to ask
what
> series of events one would go through to accomplish the following
scenario.
>
> Server A - Has your System DB's and User DB's. There are backups of the
> Master DB, MSDB DB, and user DB's.
>
> Server B - A new server, possibly a server used for a disaster recovery
> scenario. Different drive letters, different set up. IE, DB files and
log
> files are now on different drives and modified locations.
>
> I need to get from the backups on Server A to Server B and be functional.
>
> I have tried this in the past and have always failed to some degree or
> another. Usually I just restore the User DB's and manually re-create all
> jobs and logins.
>
> I have tried to start the server in single user mode, then run
sqlservr.exe
> -c -m, restore the master, and that is as far as I make it that way.
>
> There must be a way to do this, can someone enlighten me as to the proper
> way to accomplish this?
>
> Thank you VERY much.
>
> Cory
>
> -----Original Message-----
> From: Ellingson Cory (RCIS)
> [mailto:mssqldba-ezmlmshield-x15634766.[Email address protected]
> Sent: Wednesday, March 30, 2005 3:53 PM
> To: LazyDBA Discussion
> Subject: Single User Mode
>
> Hello all
>
> I am trying to restore the master to a new server, and I need to get the
> server into single user mode, and BOL has not helped thus far...What am I
> missing? I have tried the sqlservr.exe -c -m from the command prompt, I
> have tried added the -c - m to the startup params...I cannot get this,
> please help!
>
> Cory Ellingson
>
> Production Services
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
> http://www.LazyDBA.com To unsubscribe:
> http://www.lazydba.com/unsubscribe.html
> For additional commands, e-mail: mssqldba-[Email address protected]
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> Website : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
> For additional commands, e-mail: mssqldba-[Email address protected]
>
>
MS Sql Server LazyDBA home page