Cory,
The books online state that you need to go in single-user mode to restore
the master or other system databases. The model-database is a system
database and so are the msdb and eventually the distribution database as
well.
After the restore of the master database, sqlserver is stopped (at least,
i think so). Did you try to restart it in single user mode from the
command prompt after the master restore?
If you can restart in single user mode, i suggest you issue the command
RESTORE DATABASE model FROM DISK= 'backupfile'
WITH MOVE 'modeldev' TO 'C:\....\model.mdf' ,
MOVE 'modellog' TO 'C:\...\model.ldf'
(I'm not sure about modeldev and modellog at your site, but that info can
be obtained with the RESTORE FILELISTONLY FROM DISK='backupfile' command)
The same thing goes for the msdb database (and the distribution database,
if you have replication).
Good luck,
Koen Borghgraef
"Ellingson Cory \(RCIS\) "
<mssqldba-ezmlmshield-x27797999.[Email address protected]
31/03/05 20:49
To
"LazyDBA Discussion" <[Email address protected]
cc
Subject
RE: Single User Mode
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