0

I could not find any solid documentation anywhere, checking any of you have seen/built an AG that looks like below. Appreciate your responses.

SQL SERVER 2016

  1. Primary - Enterprise edition
  2. Secondary 1 - Enterprise edition - with Sync Replication
  3. Secondary 2 - Standard Edition with Async Replication

Thank you

closed as unclear what you're asking by Laurenz Albe, LowlyDBA, mustaccio, Marco, Marcello Miorelli Oct 3 at 9:41

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

2

You might missed that the Availability Groups are only available in Enterprise Edition.

In you scenario (with mixed edition), you would neither able to do following AG Configuration:

Availability Groups
Required all replicas running Enterprise Edition

Basic Availability groups (limitations)
It limit to two replicas only

Distributed Availability groups
Standard Edition only support Basic Availability Groups and Basic Availability Groups cannot be part of Distributed AGs

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