RATE THIS ANSWER
0
Click to Vote:
0
0
Last Answered:
Apr 10 2008 1:40 PM GMT
by BRennels
I know that SQL server has built in log shipping and 2005 has some improved mirroring capabilities but not sure that is going to get you what you want. I have used Double-Take software hundreds of times to replicate multiple SQL databases and log files to WAN locations several thousands of miles apart. Then the nice thing about that is you can utilize it as a DR or high availability solution as well so it isn't just a backup. Here is a link that may provide you some more information http://www.doubletake.com/applications/sql-recovery.aspx