Sql 2005 Wan Replication

Hello Experts,

A customer has one SQL 2005 STD with some databases. Whats the best way to replicate (failover) data to another SQL 2005 machine using 2Mbit Wan Link ?

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Couple of questions:

How many databases need to be protected
How big are the databases
How fast do you need it to fail over?

If it's just one or two databases, you could use Database Mirroring and depending on how fast you need failover, you could use either Synchronous or Asynchronous modes. Check it out in BOL.

If your databases are over 20GB; a 2MB MPLS Link has a physical limit of 19GB/Throughput in any 24 hours.

Again, if your DB's are big; I would NOT reccomend the likes of Double-Take, WANSync, etc if you have your SQL Server configured with the Data and Log directories on different RAID volumes.

DT et al cannot gurantee the write sequence for the data/transation log when replicated; As I found out the hard way.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial

I must respectfully disagree with the previous poster.  I can indeed say that Double-Take can safely protect larger databases, and have clients who have done so frequently without fault.  While there may always be problems with any solution (no matter the vendor) we have proven that the product can maintain write-order integrity for any application running on Windows Server.

I am an employee of Double-Take Software
Please do NOT assign points to this answer, as it is posted for informational purposes only.
For further info, please feel free to contact info@doubletake.com
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.