I have already written about Database Mirroring and Log shipping in my previous posts. Both Database Mirroring and Failover Clusters provide the following benefits:
Note: If you buy something from our links, we might earn a commission. See our disclosure statement.
There are two different types of High Availability and Failover options using WIndows Clusters from SQL Server 2012 Onward.
In this post, I would be only talking about the first option, which is SQL Server High Availability using “Failover Clustering”
With Always On Failover Clustering, you get the following benefits:
Additional Licensing implications may be applicable. This technology is also available in SQL Server Standard Edition, restricted up-to 2 nodes.
The requirement for a shared storage, makes storage as the single point of failure.
Other Services, like Reporting Services (SSRS) or Integration Services (SSIS) are not cluster aware.
In the next post of this series, I will run you through the Failover Cluster checklist prior to installation.
Comments are closed.