Read-Scale Availability Group between a Transactional subscriber and another machine I am trying to configure Read-Scale replica between a transactional subscriber and a 3rd machine. I could create the group. But, when i attempted to add the DB (which is a transactional - subscriber) to be part of my read scale replica group, I am getting the following message and not able to complete my read scale replica. My replication is already configured and working fine. Configured the AG as well. All i am doing is, trying to add the DB to the AG.
Here is the message:
Special considerations exist when adding a replication Subscriber database to an availability group. For more information, see &quot;Replication and Availability Groups&quot; in SQL Server Books Online.
But the BOL is not saying anything about AG on a subscriber. Any help on this would be highly appreciated.
what sql server version are you using?
The distribution database cannot be placed in an availability group with SQL Server 2012 and SQL Server 2014. Placing the distribution database into an availability group is supported with SQL 2016 and greater, except for distribution databases used in merge, bidirectional, or peer-to-peer replication topologies