Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
mirrored database - options for replicating to a remote site

Answered mirrored database - options for replicating to a remote site

  • Thursday, February 16, 2012 7:22 PM
     
     
    Sign In to Vote
    0

    We've got a site that is running a mirrored database based on SQL 2008 R2 Enterprise nodes. SQL #1 being the primary for applicaiton to access and SQL #2 being a mirrored partner with a witness SQL running on site.

    we've got a requirement now to raise a remote georgaphical site (we're talking WAN, 10 - 20 Mbit/Sec link)  that would contain a copy of the database in case of primary site complete failure.

    i am trying to udnerstand what are our options in replicating database data to the remote site with least data loss period.

    any brilliant ideas on the issue are much appreciated.:)

    rgds,

    yan

    Yan Doldonov Crucel


    • Edited by Crucel Thursday, February 16, 2012 7:23 PM
    •  
     

All Replies

  • Thursday, February 16, 2012 7:42 PM
     
     Answered
    Sign In to Vote
    0

    Hello,

    We use Database Mirroring between two different Datacenters, one on each coast, and it works perfectly fine

    Regards

    Javier Villegas | @javier_vill | http://sql-javier-villegas.blogspot.com/

    Please click "Propose As Answer" if a post solves your problem or "Vote As Helpful" if a post has been useful to you

     
  • Thursday, February 16, 2012 9:08 PM
     
     Answered
    Sign In to Vote
    0
    You can use Log-shipping / SAN snapshot replications onto new data center ... I hope you have already configured db mirroring wirth in primary data center databases.

    http://uk.linkedin.com/in/ramjaddu

     
  • Friday, February 17, 2012 6:23 AM
     
     Answered
    Sign In to Vote
    0
    As long as you have mirroring in your local datacenter already (and need it for HA purposes) you should maybe consider migrating to SQL 2012 and AlwaysOn. If this is not an option I agree with RamJaddu to go for Log-Shipping.
     
  • Friday, February 17, 2012 8:56 AM
     
     
    Sign In to Vote
    0

    thank you all! very useful.

    we're picking up a client site which has been setup already by someone else prior to our involvement. unfurtunately it's already now in full production phase with external clients accessing realtime database.

    a requirement now is to build a reserve remote site to pick up as part of a disaster recovery plan.

    we are now in process of investigating topology trying to fully understand existing configuration.

    SQL 2012 is not an option as it's a a custom software product which has been developed by a 3-d party and the SQL config has been specified as part of the underlying platform.

    appreciate all the feedback.

    Yan Doldonov Crucel

     
  • Friday, February 17, 2012 11:02 AM
     
     
    Sign In to Vote
    0
    Can you pls mark it answer - If it answer your question and help others to find the solution quickly

    http://uk.linkedin.com/in/ramjaddu