Thanks for your patience in fielding yet another replication design question.
I want to be able to fail over and back my 24x7 SQL DB to another VM in case the first instance fails or more likely when I have to patch SQL. I have Veeam backups. I failover and back with dual Exchange 2010 DB servers for those of you who know what a DAG is but I'm not up on SQL.
I have twin VMWare hosts and ISCSI SAN storage. I can create more VM's and add SQL licenses if necessary.
I'm on SQL 2012 and am open to going to 2016.
I have about a dozen client PCs with the SQL server name and DB name manually entered into the app. So I have to keep the same server name and DB name or touch them all at failover/failback.
Can someone guide me towards what would be the simplest (not necessarily the cheapest) solution?
If I've left out any relevant details please let me know.