• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 175
  • Last Modified:

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
1 Solution
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.
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.
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.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now