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.
|Transactional Replication||YesNote: 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)