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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
SaffronThePuppyAuthor Commented:
This confirms. Thank you.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Hyper-V

From novice to tech pro — start learning today.