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