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.
SQL Server 2005 High Availability on DotNetRocks
Install, Upgrade & AdminSQL & Data
Archived post from 2007. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.