<div>
<blockquote>
Rather than a Windows Failover Cluster (what I assume you're referring to), you might want to consider something like AlwaysOn (...)
</blockquote>
Well, AlwaysOn needs WFC, so he will always need to set a Wndows Cluster.<br />
<br />

<blockquote>
I have a SQL DB that is used for payroll and I have to provided redundancy to the DB at all times..
</blockquote>
What are the RTO (recovery time objective) and RPO (recovery point objective) requirements?
</div>


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

<div>
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.
</div>


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.

<div>
<div class="content wysiwyg-content">
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)<br />
The sites are in the same Windows Security domain, with an MPLS 100Mb connection between them.<br />
<br />
I have a SQL DB that is used for payroll and I have to provided redundancy to the DB at all times..
</div>
</div>


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

SQL 2012 cluster how to..

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.