November 2, 2018 at 6:33 pm
Hi,
I would like to build the following combination of a Windows Server Failover Clustered SQL instance and an SQL availability Group.
Platforms = Windows Server 2016 Datacenter & SQL 2016
Site A contains SQL Node 1 of a stretched SQL WSFC Instance.
Site B contains SQL Node 2 of the SQL WSFC Instance.
Site C contains an additional file share witness for the WSFC
Windows 2016 Storage replication will handle the shared disk / replication requirements. (Latency is below 5ms between site A & Site B, Stretched VLAN is also in place.
Can I use an SQL availability group to replicate the database from the active SQL WSFC node to an additional SQL server in site C? (Async Manual commit mode due the distance to site C)
Can this be done with a basic availability group on SQL 2016 Standard edition?
If It does require SQL enterprise edition, does this configuration require more than one SQL 2016 enterprise edition license for the number of core in use + SA? (Assuming the Site C AG replica is not being used for backup’s, reporting etc).
Is the above a supported configuration?
TIA.
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply