Today I had detached a database in SQL SERVER USING sp_detach.
The operation should have been pretty instant, but after a few minutes I realised something was up.
The database was stuck 'in transition', or so it appeared to Management Studio. I contemplated what to do. I wanted to avoid restarting the service and leaving the db in an inconsistent state, and hence googled the following...
Error 952 Database is in Transition
As it happens, the database isn't stuck at all, it's just Management Studio thinks it is.
solution. RESTART MANAGEMENT STUDIO.
The operation should have been pretty instant, but after a few minutes I realised something was up.
The database was stuck 'in transition', or so it appeared to Management Studio. I contemplated what to do. I wanted to avoid restarting the service and leaving the db in an inconsistent state, and hence googled the following...
Error 952 Database is in Transition
As it happens, the database isn't stuck at all, it's just Management Studio thinks it is.
solution. RESTART MANAGEMENT STUDIO.
Thank you, Arun Ladha! I have bumped into this problem several times over the past few years, and I always had to stop and start the MS-SQL Service.
ReplyDeleteNot very often the answer is really so simple ... and so unexpected.
thx - same here! this time i "googled" you ;o)
ReplyDelete