June 13, 2005 at 11:41 am
I used instructions from Microsoft http://support.microsoft.com/default.aspx?scid=kb;en-us;224071 to attempt to move the msdb database to a new disk on the same server. The instructions say to add a trace flag to the startup parameters, detach msdb, move the file(s), remove the trace flag, restart SQL Server, and reattach the msdb database. But after removing the trace flag and stopping SQL Server, I can't restart it! The Event log says "Could not find database ID 3. Database may not be activated yet or may be in transition." Help!
June 13, 2005 at 11:55 am
Turns out it's best not to detach msdb and model at the same time. Started SQL in single user mode to get past this problem.
June 13, 2005 at 4:54 pm
It is possible to move them both at the same time, but everything needs to be done in the correct order. In my checklist for moving system databases, adapted from Microsoft Knowledgebase information, I outline these steps.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply