Thursday, March 29, 2012

Error 952 Database is in Transition

One of our SQL 2005 database started to give us "Database is in
transition...Error 952". We were trying to Take the DB offline when this
problem occurred. Restarting SQL service did not help us. We were unable to do anything with this database as we were unable to obtain any locks.

What resolved the problem? Re-starting manamgement studio on client machine.
Go Figure!

Thank YOU for this post. We could not turn of the SQL Service as have more than one db active. This is definitely a bug...you try to take a db offline but it does not go, just stays inaccessible and in the "transition" state. Closing Management Studio released whatever locks were still alive and we could reconnect fine.

Thank you again.

|||I agree on the other comments: it worked out very fine with no server stop.
Thanks for your post.|||

SJ100,

Thanks for posting this. It saved my customer at 5am this morning...

I will be opening a case with MS to see if this is a known bug, or "by design" behavior.

Kevin3NF

http://kevin3nf.blogspot.com

|||Thanks mate!|||Thanks folks! It saved my day.|||

I simply stop-start SQL Server Service using Mgmt Studio and it worked for me!

-P

|||one more time, thanks a lot|||

It worked for me too, closing a forgotten QueryAnalayzer solve the problem on a sql2000 database.

Thanks a lot again.

No comments:

Post a Comment