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

MS Sql Server LazyDBA home page