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
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page