SQL server in a Hyper-V cluster

hello experts
I want to configure HA for one application that is using an SQL database . I created my cluster every thing is OK .

My idea is to create an Hyper-V VM in the cluster env and install SQL on it (Non Clustered) and put the databases files in a Shared disk . so that when one node fails the VM can continue to the other Node

Would it work?

I saw that there is an option to install SQL for cluster but not being an expert of SQL I'm a bit reluctant to go that way
gazambeyIT CONSULTANTAsked:
Who is Participating?
 
smiliefaceConnect With a Mentor Commented:
Yes, that should work. We use the same in VMWare.

So long as all the disks etc. are part of the shared infrastructure then it should fail over.

Note - this can give better uptimes than SQL Clustering as you don't have to restart when the SQL Instance "fails" over.

Warning - SQL goes down when the VM gets rebooted, e.g. for Windows patches etc. To avoid that you can do SQL Clustering on top of Virtualisation.

If you are genuinely looking for a highly available environment then you may need to get someone in who can help you put together a full solution.
0
 
RantCanSr. Systems AdministratorCommented:
In this scenario, you are simply engineering the Failover on the Hyper-v side, not in the native SQL clustering.
Sounds right; I recommend validating through testing.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.