bidirectional-transactional-replication.md

title	Bidirectional Transactional Replication | Microsoft Docs
ms.custom
ms.date	03/04/2017
ms.prod	sql-server-2016
ms.reviewer
ms.suite
ms.technology	replication
ms.tgt_pltfrm
ms.topic	article
helpviewer_keywords	bidirectional replication transactional replication, bidirectional replication bidirectional transactional replication
ms.assetid	98772e95-67ed-4010-8108-5113dbe709ff
caps.latest.revision	27
author	BYHAM
ms.author	rickbyh
manager	jhubbard

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 [!INCLUDEssVersion2005] and later versions, this topology is also supported by peer-to-peer transactional replication, but bidirectional replication can provide improved performance.

See Also

Peer-to-Peer Transactional Replication