SQL Server 2012 High Availability options
Posted on 2014-03-28
I have a web-based application based on SQL Server 2012 which we want to have highly available, meaning 2 separate SQL servers in the same datacenter 'in sync' with each other, and a process whereby if the main SQL server fails, within a minute or so the application servers are talking to the backup SQL.
We also have a 2nd datacenter with 1 SQL server which we'd also like in the pool if possible.
I know SQL Standard and Enterprise 2012 offer AlwaysOn, but that is the only feature that matters to me and differentiates them from SQL Web, and the price difference is huge.
Can anyone recommend a 3rd party product to do this? Perhaps Doubletake or something similar?