November 24, 2004 at 7:38 am
Hi there,
I have a problem!!
I was moving some of my system db's to other drives. This included the model database. Followed the correct steps to the tee, setting the right parameters & so forth. Restarted SQL server & everything looked & worked fine.
This morning we did a server reboot & the model database dissapeared!! It does not want to restore or attach now..
Does anyone have any idea of how I can recover my model db again??
Thanks in advance!!
T.
November 24, 2004 at 7:51 am
That is weird. You can copy the data and log files for model database from another server and attach them on this server.
November 24, 2004 at 8:00 am
did you check the error log and are you sure that the pathing for attaching them is correct?
November 24, 2004 at 8:01 am
Nope!!
Just tried it, same error...
I picked something up, it dissapeared from sysdatabases as well...
November 24, 2004 at 8:08 am
Try to attach it, no luck...
Try to restore, no luck...
November 24, 2004 at 9:51 am
What error messages are you getting when you try to attach or restore?
Exacty what steps are you taking when you try to attach?
Have you tried copying model.mdf and modellog.ldf from another server and attaching those?
Steve
November 24, 2004 at 10:16 pm
The message when trying to restore or attach is...
"Error 1807: Could not obtain exclusive lock on database "MODEL". Retry the operation later"
I tried to attach the db using Enterprise Manager & using sp_attach_db in T/SQL.
Yes, I also tried to attach & restore another servers' model db, but no luck, the same error comes up.
Thanks!!
August 31, 2005 at 2:04 pm
you probably attached msdb back before attaching model back. In this case add startup traceflag -T3608 (to only recover master db on startup) then detach msdb. Accordingly you would now attach model and then msdb.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply