log Shipping on a high latency connection

Last post 10-13-2008 8:10 AM by moh_hassan20. 3 replies.
Page 1 of 1 (4 items)
Active Topics My Discussions Unanswered Sort Posts: Previous Next
  • 09-17-2008 4:36 PM

    log Shipping on a high latency connection

    I am looking at implementing log shipping on a connection with network latencies of 1000ms on average.

    I am concerned about how well the backup file writing process will work across a network like this.

     

    Latency between the two databases overall is not a large concern in this case a long as the process will run reliably. 

     
    Anybody have insights?
     

  • 09-18-2008 3:27 AM In reply to

    • satya
    • Top 10 Contributor
    • Joined on 11-05-2002
    • United Kingdom
    • Posts 22,515
    • Microsoft MVP
      Moderator

    Re: log Shipping on a high latency connection

    Welcome to the forums.

    What is the interval of log shipping you are planning?

    Say if it is 15 minutes then you should consider the number of transactions that are consumed on SQL level which means the size of Transaction log file and copying the same from primary to secondary will consume fair amount of time. I don't see any issue as of now but you are at best to test the same to adopt a correct interval of log shipping between the servers.

    -Satya S K J

    SQL Server MVP



    Knowledge is Power, you will gain by sharing it. SSQA.net - Invisible contributions to the users & visible success in SQL Community.
  • 10-12-2008 10:42 AM In reply to

    • gurucb
    • Top 100 Contributor
    • Joined on 04-02-2005
    • India
    • Posts 153

    Re: log Shipping on a high latency connection

    Since network latencies are mentioned (assuming slow network) may be it would be better to backup -> Zip Backup file -> copy -> Restore. this will reduce network load as well :). But as moderator said you are the best judge.

    As regards to compression you can use WinZip API or .net frame work in built classes to do that.

  • 10-13-2008 8:10 AM In reply to

    Re: log Shipping on a high latency connection

    Latency should be resolved by vendor based on your SLA. It should be 100- 250 ms at maximum

    What data link you use: FR, ATM,.. and bandwidth.

    How you measured the latency. ?

    MCSE , MCITP (SQL 2005 Administration & Development), MCTS, MCPD
Page 1 of 1 (4 items)
Active Topics   My Discussions    Unanswered Posts


© 2000 - 2007 vDerivatives Limited All Rights Reserved.