Sql 2005 Wan Replication

Posted on 2008-11-11
Medium Priority
Last Modified: 2012-08-13
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 ?

Question by:tullioc
LVL 13

Accepted Solution

St3veMax earned 2000 total points
ID: 22930830
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.


Expert Comment

ID: 23272441

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

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question