We have datacenters in the US and Ireland and need to synchronize the MS SQL databases. The latency between the sites is 125 - 150 ms so our bandwidth is limited to ~2.0 Mbps. We need to synchronize the databases as close to real-time as possible. What is the best solution?
We are currently performing log shipping for backup purposes over the VPN which consumes much of the available bandwidth. Any insight would be greatly appreciated.