0

1 have 2 sql servers.

Svr1 is enterprise edition and Svr2 is standard edition.

Both have their own independant FCI.

Svr1 has got 60 production dbs. Svr2 has got 10 reporting dbs and multiple etls.

Presently the etls running on Svr2 fetch data from 5 dbs from Svr1 and insert data into one/more reporting dbs on Svr2.

I want to sync 5 dbs from Svr1 into Svr2 so that reporting tools and etl on Svr2 has access to copy of those dbs on Svr2 itself.

The sync need not be real time and a delay of 15 minutes is acceptable.

I am exploring SQL AG asynchronous with readable secondary for this.

Link: https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/basic-availability-groups-always-on-availability-groups?view=sql-server-ver16#limitations

It says: Basic AG - No read access on secondary replica. But in my case the primary is enterprise which I assume means that the AG that I create is not basic but full fledged AG. I'm not able to get documentation regarding this that- what a AG is basic and when it is not basic.

This link says about the readable secondary that I am talking about: https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/configure-read-scale-availability-groups?view=sql-server-ver16

But there is no information about license on the secondary server.

Questions:

  1. Does enterprise edition primary and standard edition secondary support readable secondary?

  2. Have I understood correctly that I can't create a group of 5 AG, instead I need to create 5 separate AGs because my secondary is having standard license?

1
  • Although it's "deprecated" feature, you can configure db mirroring for those 5 dbs and generate db snapshots when you need to read data from secondary mirrored dbs. Aug 31, 2022 at 16:40

1 Answer 1

3

Does enterprise edition primary and standard edition secondary support readable secondary

No. Standard Edition can only use Basic AGs, and EE can't use Basic AGs. So you can't have any sort of AG between the two servers.

enter image description here

Editions and supported features of SQL Server 2019

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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