I have two SQL Server 2017 Standard Edition clusters, each in a different datacenter, only a pair of servers each.
I was able to configure and test the Windows Cluster, Quorum for it, AG, including failing over from primary to secondary, and created one listener for each.
How do you think I can replicate to second DC?
I can't upgrade to SQL Server Enterprise to use Distributed AG.
Best Answer
Standard Edition availability groups are limited to one replica, which is clearly stated in the documentation at Basic Always On availability groups for a single database. So if you need to maintain a another copy, you'll need to use a different option.
Some possibilities are: