In the latest edition of .Net Rocks Allan Hirt discusses high availability in SQL Server 2005. This episode provides a great insight to the things that you need to be aware of when developing solutions for high availability. The show also provides a great overview of the different features that can be used with SQL Server for high availability such as clustering and database mirroring. The show can be downloaded from here.
