Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Bidirectional Transactional Replication

Bidirectional transactional replication is a specific transactional replication topology that allows two servers to exchange changes with each other: each server publishes data and then subscribes to a publication with the same data from the other server. The @loopback_detection parameter of sp_addsubscription (Transact-SQL) is set to TRUE to ensure that changes are only sent to the Subscriber and do not result in the change being sent back to the Publisher.

In SQL Server 2005 and later versions, this topology is also supported by peer-to-peer transactional replication, but bidirectional replication can provide improved performance.

To configure bidirectional transactional replication

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2014 Microsoft. All rights reserved.