• 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 then have 2 thirds of the article on a proprietary product...

    Shame on you SQLServerCentral. You just went down in my estimations.