Windows: 2012 R2 Standard SQL: SQL 2014 Enterprise Edition Setup: Two Node Windows Failover cluster with SAN
We want to introduce Availability Group to the instance by adding a second SQL instance running at a DR site. It will be Virtual server with attached drive. For Clarity, we will call SQL instance running on two node cluster with SAN as S1 and second SQL instance at DR site as S2
Can we create AG groups after Adding S2 to S1 cluster? In the event of S1 failure and it failsover to Node 2, would AGs failover to S2 instance?
Start fresh by creating two instances on new servers setup with AG and then migrate DBs to them?
Licensing - Do we have to pay licensing for both Primary and Secondary instance even though everything will be running on Primary and will failover in the event if Primary goes downs?