Restore master, model, and msdb fails

I'm attempting a full restore of one SQL 2005 Server to a new server.  I'm able to restore master without issue and then the trouble starts.  The paths are a little different, but I'm able to recreate the needed paths and use them with the new copy of master and have it come online.

I will paste the exact error below but want to qualify a couple of things.  First, I have tried this with two source servers now and two destination servers.  I thought perhaps my first attempt was a corrupt system either on the source or destination, but a completely separate environment produced identical results.  Second, I'm familiar with the process in SQL 2000.  I have done this literally a hundred times in SQL 2000 without issue.  This is my first attempt in SQL 2005.  Third, these are regular backups made by running BACKUP DATABASE model TO DISK = 'e:\hold\model.bak' and so on for the rest of the system db's.

My first step was to bring a SQL 2005 server online and upgrade to SP2, the same as my source servers.  I then created a backup of master, model, and msdb.  Then I turn to my new server, stop SQL, run SQL from the command line with -c -m -T3608.  Restore master goes fine and SQL stops.  I then start SQL with -c -T3608 and attempt to restore model and msdb.  Here's what I get:

For model:
Processed 144 pages for database 'model', file 'modeldev' on file 1.
Processed 1 pages for database 'model', file 'modellog' on file 1.
Msg 3283, Level 16, State 1, Line 1
The file "modellog" failed to initialize correctly. Examine the error logs for more details.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

And msdb:
Processed 12256 pages for database 'msdb', file 'MSDBData' on file 1.
Processed 7 pages for database 'msdb', file 'MSDBLog' on file 1.
Msg 3283, Level 16, State 1, Line 1
The file "MSDBLog" failed to initialize correctly. Examine the error logs for more details.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

Your help is greatly appreciated.  I've been arguing with Microsoft support for a week.  I'm not even sure they understand the problem.


LVL 5
BryanMIAsked:
Who is Participating?
 
pai_prasadConnect With a Mentor Commented:
can u post the exact steps to restore for model and msdb?
r the paths for model and msdb diff from the one in backup?
did u look @ this

http://support.microsoft.com/kb/224071

>>Restore master goes fine and SQL stops
r u saying after the restore SQL aborts abrubtly or SQL doesnt restart ???

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.