There are many limitations to Always On for Standard Edition, and they are all documented here. Basically, you get to use a single availability database with a single secondary replica, with no read access on the secondary replica.
Issue:
Unable to setup readable secondary databases on SQL Server 2019 Standard Edition
Fix:
Upgrade from Standard Edition to Enterprise or Developer Edition.
Sources:
https://www.madeiradata.com/post/always-on-availability-groups-in-standard-edition
Comments