SQL Server Performance

Some thoughts... Feedback is appreciated.

Discussion in 'SQL Server Log Shipping' started by photura, Jun 14, 2006.

  1. photura New Member

    Hello all:

    I have a couple of thoughts regarding my current environment and would appreciate your thoughts as well.

    We currently replicate data every 15 mintues between the US and a few International cities.

    Separately, we have a disaster recovery site in the US. This site had log shipping setup. But, as you'll see from a former post, is failing miserably.

    Here's my thought that I'd like feedback on:

    If we're replicating successfully Internationally every 15 minutes, why not add the DR site as a Subscription to the existing Replication and get rid of Log Shipping?

    Can you see any benefits to log shipping to a standy server as opposed to replication??

    Thanks for the brainstorm.

  2. satya Moderator

    I think Log shipping is easy to manage than replication, in your case make sure the network link between the 2 sites is working fine without any glitch. For a standby solution I suggest always Log shipping and not replication.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided �AS IS� with no rights for the sake of knowledge sharing.

Share This Page