Skrevet av Emne: SQL Server: Offline database takes forever, hangs  (Lest 4112 ganger)

ATC

  • Gjest
SQL Server: Offline database takes forever, hangs
« på: 05. August 2009, 10:50 am »
  • [applaud]0
  • [smite]0
  • When trying to take a database offline, the database hangs in "transition mode".



    ATC

    • Gjest
    [Solved] SQL Server: Offline database takes forever, hangs
    « Svar #1 på: 05. August 2009, 10:50 am »
  • [applaud]0
  • [smite]0
  • 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.