Transactional Replication and Always On Availability Groups Support Update


In the past, we have received multiple requests from customers for supporting transactional replication republishers in an Always On Availability Group configuration. We are pleased to announce that starting from SQL Server 2016, transactional replication republisher is supported in an Always On Availability Group configuration. See “Replication, Change Tracking, Change Data Capture, and Always On Availability Groups (SQL Server)” for more details.The table below shows the supported combinations of replication on Always On Availability Groups.

  Publisher Distributor Subscriber
Transactional Replication Yes
Note: Does not include support for bi-directional and reciprocal transactional replication
No Yes

Transactional replication subscribers do not need special handling while participating in Always On Availability Groups. Subscribers must be running SQL Server 2012 or later to participate in an availability group. For more information, see Replication Subscribers and Always On Availability Groups (SQL Server)

Amit Banerjee

@banerjeeamit

Comments (1)

  1. Neeraj Mittal says:

    Thanks Amit for sharing. another cool enhancements in 2016

Skip to main content