Were looking into similar ideas
Currently checking out DoubleTake software
Apparently does environment as well as SQL server
Also looking at 2008 db mirroring
http://www.doubletake.com/_docs/swf/dt-flashdemo/index.htm
http://www.microsoft.com/sqlserver/2008/en/us/high-availability.aspx