Skip to main content
added 271 characters in body
Source Link

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

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.

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

Source Link

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.