SQL Server Performance

differences between Log shipping & Replication

Discussion in 'SQL Server Log Shipping' started by RAJENDRA, Mar 27, 2006.

  1. RAJENDRA New Member

    Hi All,

    Please let know what are main differences between Logshipping & Transactional Replication.

    Thanks & Regards,

    Rajendra.

    rajendra
    RAJENDRA, Mar 27, 2006
    #2

  2. sachinsamuel New Member

    sachinsamuel, Mar 27, 2006
    #2

  3. satya Moderator

    Both are used to manage the data consistency, log shipping is defined to the database and replication is granulated to table-column level.

    For the high availability warm standby option better use Log shipping than replication. Replication is better to use if you want to collate the data on a central location with updates.

    Satya SKJ
    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.
    satya, Mar 27, 2006
    #2

Share This Page