2-node HA MS SQL on Hyper-V without shared storage (SAN)

I have 2 pizza boxes, each with 2 nics and have a mind to run Hyper-V on each one in order to set up a Windows and SQL Cluster for HA.
I have no shared SAN available. I understand that Windows 2012 / SQL 2012 can do this?
Can anyone describe the shared components or link me to some procedures/recipes online please?
I only need 1 DB synced between the pair.
Config is:
2x Hyper-V Hosts with local disk and heartbeat crossover cable and seperate 1Gb link to LAN.
1x Windows VM with 1x SQL instance per Host.

Much appreciated!

Kevin
SaffronThePuppyAsked:
Who is Participating?
 
Cliff GaliherCommented:
A traditional cluster requires shared storage. That hasn't changed with Windows or SQL server 2012.   SQL server 2012 did add a new feature called AlwaysOn that allows groups of databases to be mirrored (no shared storage required) and failed over as a group.  However establishing quorum still requires some sort of shared storage Whether that be a SAN, or in server 2012, an SMB share based witness, you'll need to be familiar with that. AlwaysOn is also an enterprise edition feature so licensing can get up there.  It sounds like you may not be quite ready to tackle this level of complexity.
0
 
ste5anSenior DeveloperCommented:
Why not building a Windows cluster and running SQL Server as cluster? I don't see the advantage in using Hyper-V here.
0
 
SaffronThePuppyAuthor Commented:
I am also running a Domain Controller VM and possibly another service on one of the nodes, or both. So there may be 3 or more VM's. This question is specifically "How to I get around using a CSV to do Hyper-V Clustering? Can it be done with local disk somehow. What about the Quorum? Can all this be done with on-board DAS? I can't use iSCSI or SMB or FC storage.

More simply put: How can I setup Windows 2012 Hyper-V Clustering with 2 physical boxes and no external storage?
0
 
SaffronThePuppyAuthor Commented:
This confirms. Thank you.
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.