« Patching a Crash in Kensington MouseWorks | Main | Entity Framework Performance Tip - Be a Minimalist »
July 30, 2009
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 at July 30, 2009 5:29 PM
Trackback Pings
TrackBack URL for this entry:
http://blog.logos.com/mt-cgi/mt-tb.cgi/300