A couple of things:

1) The easiest way to kill all spids is actually to go through the "detach database" form, which allows you to kill all active processes. You do not actually have to detach the database for it, it's just a convenience given to you with courtesy of MS (and for some reason is only found in the "Detach DB" winform).

2) There has to be a better way to have your database server redundant. Starting with a clustered active-passive two server configuration, through a raid 10 disk array, with spare parts sitting around just for those few remaining single points of failure (e.g. raid controller). Wouldn't you agree?