The DotNetRocks podcast this week has Alan Hirt talking about SQL Server 2005 high availability. I haven't listened to the show yet but it's downloaded and on my list for tomorrow.
I'm not sure how much will be applicable to GP since we don't have a lot of control from a developer standpoint but it should give you a nice overview of the general options.