Sql 2005 Wan Replication

Posted on 2008-11-11
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

    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.

    LVL 2

    Expert Comment


    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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    APEX (Application Express) is used to develop a web application from Oracle. SQL Workshop is one of the tools that comes with Oracle APEX to query or modify the database objects or to make any changes to the structure.
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    761 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

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now