SQL Server Performance

Replication or Log Shipping

Discussion in 'Performance Tuning for SQL Server Replication' started by Jason88, Mar 3, 2005.

  1. Jason88 New Member

    [:I]<br /><br />Hi,<br /><br />Now that the Log Shipping and Replication are set up OK, and basically they are testing fine.<br />But I'm wondering which solution I should use? Log Shipping or Replication?<br />Would someone please give me some advise? Thanks.[<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />Jason
  2. satya Moderator

    Log shipping is based on the database wide solution and Replication is granuled to the object level.
    For the hot standby I prefer Log shipping and less hasle as compared to the replication.

    Satya SKJ
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page