We are looking to set up a failover system for a single VM running Server 2012 R2 and SQL Server 2014 Standard. We have the following hardware and software:
2x HP Proliant DL360p Gen8 server, 2 PSUs each
1x HP MSA1040 with Ethernet SFP modules, 2 controllers and PSUs
Switches and cables as required for redundant iSCSI connections
2x Server 2012 R2 Standard (licensed for host OS and 2x VMs per server)
1x SQL Server 2014 Standard (10 CALs)
The goal is to use Hyper-V and shared storage on the MSA so that in the event of a failure on the host server that is running the VM, it fails over within a few minutes to the other.
Without adding further hardware or software, what's the best method to achieve the goal? Thanks in advance!