Unanswered: 2 Nodes in a Geo-Cluster. Best solution?
I want a (light) HA/DR solution..
Users works via VPN that is connected to a Datacenter (Primary site) where all servers are located. Its very, very crucial that the Users can access the Database even if their Internet is down at their company (Secondary site). If the Primary site goes down, it will Automatic Failover to the Secondary site (where Users are working).
Is AlwaysOn the best solution here, and where should I place the File witness. I don't want the cluster to go offline on me. :-) I have checked out Replication, it seems flaky..
I have SQL 2016 Standard license, and can use two SQL servers. I know its not much..