| title | Bidirectional Transactional Replication | Microsoft Docs | |||
|---|---|---|---|---|
| ms.custom | ||||
| ms.date | 06/13/2017 | |||
| ms.prod | sql-server-2014 | |||
| ms.reviewer | ||||
| ms.technology | replication | |||
| ms.topic | conceptual | |||
| helpviewer_keywords |
|
|||
| ms.assetid | 98772e95-67ed-4010-8108-5113dbe709ff | |||
| author | MashaMSFT | |||
| ms.author | mathoma | |||
| manager | craigg |
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 [!INCLUDEssVersion2005] and later versions, this topology is also supported by peer-to-peer transactional replication, but bidirectional replication can provide improved performance.