Transactional Replication and Always On Availability Groups Support Update

Published Mar 23 2019 02:43 PM 232 Views
Microsoft
First published on MSDN on Aug 31, 2016

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 Serve... ” 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

%3CLINGO-SUB%20id%3D%22lingo-sub-384790%22%20slang%3D%22en-US%22%3ETransactional%20Replication%20and%20Always%20On%20Availability%20Groups%20Support%20Update%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-384790%22%20slang%3D%22en-US%22%3E%0A%20%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CSTRONG%3E%20First%20published%20on%20MSDN%20on%20Aug%2031%2C%202016%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3E%3CP%3EIn%20the%20past%2C%20we%20have%20received%20multiple%20requests%20from%20customers%20for%20supporting%20transactional%20replication%20republishers%20in%20an%20Always%20On%20Availability%20Group%20configuration.%20We%20are%20pleased%20to%20announce%20that%20starting%20from%20SQL%20Server%202016%2C%20transactional%20replication%20republisher%20is%20supported%20in%20an%20Always%20On%20Availability%20Group%20configuration.%20See%20%E2%80%9C%20%3CA%20href%3D%22https%3A%2F%2Fmsdn.microsoft.com%2Fen-us%2Flibrary%2Fhh403414.aspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20Replication%2C%20Change%20Tracking%2C%20Change%20Data%20Capture%2C%20and%20Always%20On%20Availability%20Groups%20(SQL%20Server)%20%3C%2FA%3E%20%E2%80%9D%20for%20more%20details.The%20table%20below%20shows%20the%20supported%20combinations%20of%20replication%20on%20Always%20On%20Availability%20Groups.%3C%2FP%3E%0A%20%20%3CTABLE%3E%0A%20%20%20%3CTBODY%3E%3CTR%3E%0A%20%20%20%20%3CTD%3E%3C%2FTD%3E%0A%20%20%20%20%3CTD%3E%3CSTRONG%3E%20Publisher%20%3C%2FSTRONG%3E%3C%2FTD%3E%0A%20%20%20%20%3CTD%3E%3CSTRONG%3E%20Distributor%20%3C%2FSTRONG%3E%3C%2FTD%3E%0A%20%20%20%20%3CTD%3E%3CSTRONG%3E%20Subscriber%20%3C%2FSTRONG%3E%3C%2FTD%3E%0A%20%20%20%3C%2FTR%3E%0A%20%20%20%3CTR%3E%0A%20%20%20%20%3CTD%3E%3CSTRONG%3E%20Transactional%20Replication%20%3C%2FSTRONG%3E%3C%2FTD%3E%0A%20%20%20%20%3CTD%3E%3CSTRONG%3EYes%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3E%20%3CEM%3E%20Note%3A%20Does%20not%20include%20support%20for%20bi-directional%20and%20reciprocal%20transactional%20replication%3C%2FEM%3E%3C%2FTD%3E%0A%20%20%20%20%3CTD%3E%3CSTRONG%3E%20No%20%3C%2FSTRONG%3E%3C%2FTD%3E%0A%20%20%20%20%3CTD%3E%3CSTRONG%3E%20Yes%20%3C%2FSTRONG%3E%3C%2FTD%3E%0A%20%20%20%3C%2FTR%3E%0A%20%20%3C%2FTBODY%3E%3C%2FTABLE%3E%0A%20%20%3CP%3ETransactional%20replication%20subscribers%20do%20not%20need%20special%20handling%20while%20participating%20in%20Always%20On%20Availability%20Groups.%20Subscribers%20must%20be%20running%20SQL%20Server%202012%20or%20later%20to%20participate%20in%20an%20availability%20group.%20For%20more%20information%2C%20see%20%3CA%20href%3D%22https%3A%2F%2Fmsdn.microsoft.com%2Fen-us%2Flibrary%2Fhh882436.aspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20Replication%20Subscribers%20and%20Always%20On%20Availability%20Groups%20(SQL%20Server)%3C%2FA%3E%3C%2FP%3E%0A%20%20%3CP%3E--%3C%2FP%3E%0A%20%20%3CP%3EAmit%20Banerjee%3C%2FP%3E%0A%20%20%3CP%3E%3CA%20href%3D%22http%3A%2F%2Ftwitter.com%2Fbanerjeeamit%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20%40banerjeeamit%20%3C%2FA%3E%3C%2FP%3E%0A%20%0A%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-384790%22%20slang%3D%22en-US%22%3EFirst%20published%20on%20MSDN%20on%20Aug%2031%2C%202016%20In%20the%20past%2C%20we%20have%20received%20multiple%20requests%20from%20customers%20for%20supporting%20transactional%20replication%20republishers%20in%20an%20Always%20On%20Availability%20Group%20configuration.%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-384790%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESQLServerTiger%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Version history
Last update:
‎Mar 23 2019 02:43 PM
Updated by: