A Few Tips For Taking a SQL Server Database Offline

In SQL Server Management Studio (SSMS), you can right-click on a database, select “Tasks” and take the database offline.


If the database seems to “hang” in the transition for more than a minute after you do this (you may be sweating bullets by this point), try the following two things:

  1. Make sure you are not profiling the database.
  2. Restart SSMS.

These simple things may save you a lot of stress!

Posted by Bill Simpkins on July 30, 2009