August 31, 2007 at 8:09 am
Yesterday, the SQL server went down hard and now after restarting, two of my databases are unaccessible. From Enterprise manager, when I drill down, I receive this error after expanding the database:
Error 913 Could not find database ID 21. Database may not be activated yet or may be in transition.
Also, I do not see in the logs where the two databases were ever recovered.
August 31, 2007 at 10:31 am
chances are master database has the wrong ID's in the sysdatabases table. sounds like they are not connected. to verify this, try to move the mdf and ldf files to a different location. if it lets you move them, they are not attached. If they are not attached, then you can do a drop database statement on the 2 databases, move the mdf and ldf files back, then reattach the databases and all should be well.
August 31, 2007 at 12:36 pm
- check your sqlserver errorlog file to find out what's going on !
(yourserverdrive:\mssql\log\errorlog = to be opened with notepad)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
August 31, 2007 at 12:59 pm
I just fixed the problem, the server was set to use Windows NT Fibers so it was starting in fiber mode instead of thread mode.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply