I do not want to manually recreate any of the logons (master) or the jobs
(msdb), so I thought this was the only way. I did see a DTS Transfer Logons
task, however, that has failed for me each and every time.

As far as getting the master restored, that has happened, I got it started -
I had to modify drive names to create the location for the model and temp
the master tries to make...now, I need to know how to modify those
locations...so far I see no real way...Ideas?

Cory Ellingson

Production Services


-----Original Message-----
From: Hugh du Toit
[mailto:mssqldba-ezmlmshield-x69636107.[Email address protected]
Sent: Thursday, March 31, 2005 1:58 PM
To: LazyDBA Discussion
Subject: RE: Single User Mode


Why restore the master database in any case? If I am rebuilding SQL on a new
server, I would install SQL, transfer logins, and restore each database on
the new server. All necessary info would be created in master... no user
procedures and functions should be in master, so only recreate roles you
created in the old server's master database on the new one...


-----Original Message-----
From: Matthew Wade [mailto:mssqldba-ezmlmshield-x72387088.[Email address
protected]
Sent: Thursday, March 31, 2005 21:50 PM
To: LazyDBA Discussion
Subject: Re: Single User Mode

Bring it up in single user mode update your sysdatabases table with the
correct path to the mdf. Restart sql server

Ellingson Cory (RCIS) wrote:

>Hey all...
>
>I think I may have found the issue, looking for any guidance as to how to
>get around this...
>
>As I stated before, the Drive names are all different on the new box I am
>trying to restore.
>
>I can successfully restore the master in single user mode, but whenever I
>try to restart the SQL Server service, it always fails, and I think here
may
>be why...
>
>2005-03-31 09:13:05.71 spid5 FCB::Open failed: Could not open device
>d:\Program Files\Microsoft SQL Server\MSSQL\data\model.mdf for virtual
>device number (VDN) 1.
>
>The "D" drive on the server b is the CD rom, not the data drive anymore...
>
>Ideas?
>
>Cory Ellingson
>
>Production Services
>
>
>-----Original Message-----
>From: Ellingson Cory (RCIS)
>[mailto:mssqldba-ezmlmshield-x9433186.[Email address protected]
>Sent: Thursday, March 31, 2005 9:18 AM
>To: LazyDBA Discussion
>Subject: RE: Single User Mode
>
>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]
>>
>>
>>
>>
>
>
>
>
>
>
>---------------------------------------------------------------------
>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]
>
>
>
>
>


---------------------------------------------------------------------
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