We were trying to take a database offline and it eventually failed fter about 5 minutes. I didn’t want to restart the SQL services or the server as there were many other databases on the server.
The simple way to fix this error is to merely close and then re-open the management studio.
How to fix Error 952 Database is in Transition on SQL 2008 SQL Management Studio
Leave a reply