none
Availability group and replication publication RRS feed

  • Question

  • I'm confused about the expected functionality and interoperability of availability groups and transactional replication. We would like our published DB to be part of an availability group. We have that up, but when we fail over to the secondary, replication doesn't not function as new DML occurs in the secondary (now primary). It does pick back up after we fail back to the original primary.  Is there a way to configure it such that replication continues seamlessly after a failover?

    Thank you!

    -Peter

    PS Here is what replication monitor has to say when the original primary is down:

    "replicated transactions are waiting for the next log backup or for the mirroring partner to catch up"

    Monday, August 10, 2015 8:15 PM

Answers

  • Hi Peter,

    Here is books online configuration for configuring replication publisher database in an availability group.

    https://msdn.microsoft.com/en-us/library/hh710046.aspx?f=255&MSPPError=-2147217396

    Regards,
    John

    Please mark as answered if this answers your question. Please also hit the up arrow on the left side if you think this response is helpful.

    Monday, August 10, 2015 10:57 PM

All replies

  • Hi Peter,

    Here is books online configuration for configuring replication publisher database in an availability group.

    https://msdn.microsoft.com/en-us/library/hh710046.aspx?f=255&MSPPError=-2147217396

    Regards,
    John

    Please mark as answered if this answers your question. Please also hit the up arrow on the left side if you think this response is helpful.

    Monday, August 10, 2015 10:57 PM
  • Yes the functionality is very slimier.

     Transnational replication you can replicate on both sides.

    It is the same with Availability groups  read/write primary and replica.

    But the underlying infrastructure is different. To Build AG you need cluster.

    where as transnational replication you do not need. 

    These features are not supported in all revisions of SQL server.

    Tuesday, August 11, 2015 6:33 AM