differences between Log shipping & Replication | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

differences between Log shipping & Replication

Hi All, Please let know what are main differences between Logshipping & Transactional Replication. Thanks & Regards, Rajendra. rajendra
please check the link below. http://www.sqlservercentral.com/columnists/pibison/logshippingvsreplication.asp regards
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
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.