Ouch! I HATE it when that happens. Here's a link, you've probably already read it (here).
Originally Posted by jpotucek
I would (in more or less this order):
1. Look carefully at the SQL Error log
2. Restart with -T3608 and attempt to re-attach model
3. Restore model from a backup (you did have a backup, right?)
I seem to recall from a distant memory that when you moved msdb and model, there was a particular sequence (one HAD to be done before the other). [Edit: here it is, smack in the middle of the link above].
I can't tell for certain from the steps you outline above which you did first.
Originally Posted by Microsoft
I have used this procedure to move model, master, msdb and tempdb on several different occasions with no trouble at all (sorry, that doesn't help you, but I did want to verify that the steps outlined above DO work). As I recall, I usually make it a point to move msdb and model in separate steps (restarting SQL Server in between moving these two dbs).
Best of luck,
Last edited by hmscott; 10-31-05 at 23:30.
Have you hugged your backup today?