0

Please we are about to implement High availability for for SQL server 2014 on our new infrastructure but i need to know which is best between SQL Failover Clustering and Always On High Availability Group. We needed to consider below as part of our requirement ; 1. Automatic Failover 2. Ensure that if storage hosting SQL database fails or get corrupted all data are moved to another Storage and still work perfectly with Automatic Failover 3. Needs to ensure that secondary(passive) node can used for reporting

I will be very happy if i can get assisted with above queries as well as advantages/Disadvantages of both Always on High availability and SQL Failover Clustering

0

Always On Availability group will server your purpose for which you will need Enterprise Edition of SQL Server license. It will provide :

  1. Automatic failover is available when the AG is configured with Synchronous-commit mode with automatic-failover.Failover Modes

  2. Since AlwaysON has data separated for each instance that is part of the AG, the storage corruption for one of the node will leave you safe with the other node/nodes.

  3. Readable secondary will help you in reporting purpose. Active Secondary

The only disadvantage/Limitation of AG I would say is the need of Enterprise edition.

  • 1
    well, and if you want readable secondary, you need to license two Enterprise servers. But you can have basic Availability Groups with SQL 2016 Standard. – Jonathan Fite Jun 22 '18 at 13:50

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.