Great article, thanks!

I keep a folder on the server called "Disaster Management". It contains everything I need in an emergency to keep my head 🙂 : scripts to find current executing processes, to display server configuration settings, to kill all connections and establish DAC connection, to enumerate log files, and to perform the restores.

This was a good discussion/presentation of killing connections and setting a DB to single user mode:

http://www.sqlservercentral.com/scripts/Maintenance/62619/

[/url].

HTH,

Rich