January 29, 2006 at 11:01 pm
What are the differences between Log Shipping and Replication?
..hema
January 30, 2006 at 3:26 am
Hi Hema,
To start with Both of the Techniques are used for maintaining High Availability, However there are certain differences in their configuration and setup.
Log shipping can be used if the data is critical and the logs need to be shipped very frequently hence the server overhead might be high.
Replication is called "Complex" process because it involves lot of things and is difficult to set unlike Log Shipping, However one biggest advantage is u can replicate only a table or a dataobject unlike Log Shipping where u need to replicate complete Database.
Replication can be divided into Three types and can be used according to the scenario
Snapshot Replication: Best,if the data is static. Let us say if a Bank(not working 24*7) wants to take a backup of its data everyday after it closes its operations, can choose Log Shipping bcos it copies the database objects exactly as they exist that moment
Transactional Replication: Best, if the data is flowing (Bank working for 24*7),when the data is getting modified.
Merge Replication: Best, if multiple users are trying to update the same data.
However Log-shipping restores the logs to the standby server with NoRecovery or with Standby - both options disallow edits to be made to the data. Replication doesn't enforce such a restriction so explicit permissions would be required to prevent changes to subscriber data.
For more info reg the same visit http://www.replicationanswers.com/Standby.asp
Cheers,
Raghu Pyapili
January 30, 2006 at 5:42 am
Hema
for a comparison of the two have a look at this article http://www.sqlservercentral.com/columnists/pibison/logshippingvsreplication.asp.
Markus
[font="Verdana"]Markus Bohse[/font]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply