SQL 2012 cluster how to..

Looking for a good site to explain how to setup a SQL 2012 cluster with 2 servers at different sites,(in case of network, or power failure)
The sites are in the same Windows Security domain, with an MPLS 100Mb connection between them.

I have a SQL DB that is used for payroll and I have to provided redundancy to the DB at all times..
sullendAsked:
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.

Ryan McCauleyEnterprise Analytics ManagerCommented:
Rather than a Windows Failover Cluster (what I assume you're referring to), you might want to consider something like AlwaysOn, which is designed for this type of scenario (and has other advantages too). A traditional Windows Failover Cluster requires shared storage, and it's harder to maintain over long distances like that. In the case of AlwaysOn, each server has its own copy of the database (and it's more like the next step in Database Mirroring, if you're familiar with that concept from SQL 2005).

http://www.tech-coffee.net/alwayson-availability-group-introduction/

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
Vitor MontalvãoMSSQL Senior EngineerCommented:
Rather than a Windows Failover Cluster (what I assume you're referring to), you might want to consider something like AlwaysOn (...)
Well, AlwaysOn needs WFC, so he will always need to set a Wndows Cluster.

I have a SQL DB that is used for payroll and I have to provided redundancy to the DB at all times..
What are the RTO (recovery time objective) and RPO (recovery point objective) requirements?
Ryan McCauleyEnterprise Analytics ManagerCommented:
Sure, AlwaysOn requires WSFC, but it doesn't require shared storage, which is the big hold-up that can wrinkle the desire to do a geo-dispersed cluster. With the newer versions of Windows, you can have the cluster use a file share for quorum instead of a disk, so there's no requirement for a single shared physical resource of any kind.
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
Microsoft SQL Server 2008

From novice to tech pro — start learning today.