June 17, 2010 at 9:04 pm
can any one tell me about what is Peer-to-Peer Replication type ?what is the difference between transational replication and peer to peer replication?
when we have to go for peer to peer replication
thanku
June 17, 2010 at 11:06 pm
Hi,
1. A transactional two way replication can be initiated by running the snapshot agent, but a peer-to-peer replication cannot be done so. A backup of the publisher DB must be retored at the database and at the time of subscription creation we need to specify that we have restored the database at the subscriber.
2. A transactional two way replication handles conflicts on its own, but a peer-to-peer replication does not.
3. A transactional two way replication is used for data availability scenarios but a peer-to-peer replication is used a scalability of user connections scenario.
4. A transactional two way replication does not support types of topologies that some customers require, such as the ring and mixed topologies but a peer-to-peer replication does support.
A good example for use of peer-to-peer replication is available at the below location. http://msdn.microsoft.com/en-us/library/cc966404.aspx
Thanks,
Lakshmi
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply