Best failover method for single VM running SQL Server in Hyper-V 2012 R2
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!
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!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That article is based on Server 2008 R2 - would it be better to take advantage of the new shared VHDX feature?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Set up and working a treat, thanks very much!
ASKER