In the shop I operate in we have been steadily moving from a .com environment where devs are actively involved in the support role (mainly cos they are the only...

Mirroring in SQL2005 looks to me like the best, cheapest option for failover if you can't afford to go enterprise (which many of my clients can't).

To not mention it and...