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.
