Tuesday, January 11, 2011

SQL Server - Take Offline - Database is in transition...

Tried to take a database offline by simply right-clicking on the database in SQL Management Studio and selecting 'Tasks > Take Offline'

The dialog box which was presented just hung for ages and afterwards when trying to access the database is was giving the error:

Database 'myDatabase' is in transition. Try the statement later.

I would not have guessed it, but this post pointed me in the direction of restarting SQL Management Studio and everything was ok again!

No comments: