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