September 18, 2007 at 1:10 pm
Hi Exports
What are Advantages of REPLICATION AND LOGSHIPing can u any body plz give all advantages of Replications and LOGSHIPPING
What are differences between REPLICATION AND LOGSHIPPING
Thx
subu
September 18, 2007 at 1:27 pm
September 19, 2007 at 2:10 am
Check these MS links:
http://msdn2.microsoft.com/en-us/library/ms151247.aspx
http://msdn2.microsoft.com/en-us/library/ms190640.aspx
Same info also in BOL
September 19, 2007 at 6:06 am
There are a lot of differences, but the purpose of the second database is the latency of the data are probably the two most important factors.
In log shipping, the second database will either be offline, or read-only. If you need to be able to update this database in any way, log shipping will not do the trick. Also, log shipping will only get updates as fast as you are willing to create log backups and copy them over.
In replication, the subscriber can be freely updated. In transactional replication, it is some additional work to get the updates back to the publisher (if this is what you want) and in merge replication, updates are pushed or pulled in both directions and conflict resolution handles updates done to the same records on both sides. In replication, you get to choose when updates are passed along - all the way down to virtually instantly (which is impossible in log shipping).
Log shipping is pretty easy to set up and replication is full of pit-falls. Every situation is different. Read the information posted earlier. If you are still unsure of what option would be the best choice, post what you are trying to do and I am sure you will get 30 or 40 people with suggestions.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply