May 16, 2008 at 2:13 pm
Hi,
We are trying to move model database from one drive to another. We have done this in past and today when we tried to do this i am getting the following error.
"Could not find database ID 3. Database may not be activated yet or may be in transition. Reissue the query once the database is available. If you do not think this error is due to a database that is transitioning its state and this error continues to occur, contact your primary support provider. Please have available for review the Microsoft SQL Server error log and any additional information relevant to the circumstances when the error occurred."
The steps we followed were.
1. Add the -c,-m,-T3608 in the sql service startup parameter.
2. detach the model database
immediately after doing the the sql service abruptly stopped and hence after if we try to start the service it fails with the error given above. Any help here to solve the problem will be greatly appreciated.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
May 16, 2008 at 2:19 pm
Have the "-c,-m,-T3608 " options been specified as three seperate paramenters? That is
Incorrect:
c,-m,-T3608
Correct:
-c
-m
-T3609
SQL = Scarcely Qualifies as a Language
May 16, 2008 at 2:20 pm
I just gave them for your reference. I have already given them as separate parameters only.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
May 16, 2008 at 3:57 pm
Used this article's excellent guidance yesterday and it's reliably good stuff...
http://www.sqlservercentral.com/articles/Administering/movingsystemdatabasesachecklist/1608/#
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply