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 "Replication and Availability Groups" 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.

  • Are you adding the subscriber database to the AG to provide scale out of read workload? If so, it might be simpler to just add the 3rd machine as another replication subscriber and get another readable copy of the replicated database that way, rather than the complexity of an AG on the subscriber DB. – HandyD Apr 19 at 5:45
  • have you read this? docs.microsoft.com/en-us/sql/database-engine/… – MBuschi Apr 19 at 6:19
  • @HandyD - Well, we tried this option but the latency is too high due to geo locations. We are trying to over come this issue using AG – IcyHot Apr 19 at 12:57
  • @MBuschi - yes. as i mentioned, we are not trying to add the publisher or distribution DBs to AG. Just adding the subscriber to AG. – IcyHot Apr 19 at 12:58
  • @IcyHot When exactly do you encounter the error message? Can you list out the steps you're trying to take and highlight which one encounters the error? – HandyD Apr 19 at 22:15

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.