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:
- Make sure you are not profiling the database.
- Restart SSMS.
These simple things may save you a lot of stress!
Posted by Bill Simpkins on July 30, 2009