Forums.ATC.no

Teknisk => Generelt teknisk => Emne startet av: ATC på 05. August 2009, 10:50 am

Tittel: SQL Server: Offline database takes forever, hangs
Skrevet av: ATC på 05. August 2009, 10:50 am

When trying to take a database offline, the database hangs in "transition mode".

Tittel: [Solved] SQL Server: Offline database takes forever, hangs
Skrevet av: ATC på 05. August 2009, 10:50 am

Try "alter database set restricted_user with rollback immediate" before setting it offline. This will terminiate user connections and rollback their transactions and only allow priviledged users to connect.

Then close the dialog and exit Server Management Studio. Restart it, and the database should be offline.