Solved

SQL 2012: What is the difference between AlwaysOn Failover Cluster Instances and AlwaysOn Availability Groups

Posted on 2015-02-17
8
753 Views
Last Modified: 2015-02-18
According to this page, SQL 2012 Standard Edition supports "AlwaysOn Failover Cluster Instances", but not "AlwaysOn Availability Groups". What is the difference?
0
Comment
Question by:R. Toby Richards
  • 3
  • 3
  • 2
8 Comments
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 40615193
Failover Cluster is a technique for High Availability.Most common FC scenario can have multiple servers acting as cluster nodes. those nodes are connected to shared drivers (i.e SAN) so One node owns all the services (The active node) and the others are on hold in case the have to quickly become active. This ensures protection on protection on the server/instance level
AlwaysOn is a SQL solution for Disaster Recovery which requires the Windows Cluster layer installed on every node, so this ensures protection at database level
0
 
LVL 5

Author Comment

by:R. Toby Richards
ID: 40615205
I know what an HA cluster is. I know what AlwaysOn is. There seem to be two different AlwaysOn types: "AlwaysOn Failover Cluster Instances" and "AlwaysOn Availability Groups". You need SQL Enterprise edition for the latter. What is the difference? I have only Standard edition. What is the difference between the AlwaysOn that I can do with that edition only, and what I could do if I had Enterprise edition?
0
 
LVL 47

Expert Comment

by:Vitor Montalvão
ID: 40616392
I think they only changed the name. "AlwaysOn Failover Cluster Instances" is the typical Failover Cluster solution for SQL Server instances. Marketing, I may say.
0
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 
LVL 5

Author Comment

by:R. Toby Richards
ID: 40616698
How sure are you? It looks to me like maybe the active instance needs to be Enterprise edition, and the failover instances can be Standard edition.
0
 
LVL 47

Expert Comment

by:Vitor Montalvão
ID: 40616709
I'm pretty sure it's only a name change so now HA has AlwaysOn on it. You can check the features for HA for each SQL Server version and you'll see by changing the version on the top of this page in earlier versions exists FCI and on 2012 & 2014 exists AlwaysOn FCI.
0
 
LVL 5

Author Comment

by:R. Toby Richards
ID: 40616902
Then why does it show EE supporting both technologies, but SE only one of them?
0
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 40616909
Which windows edition you are using ? is it EE ?
0
 
LVL 47

Accepted Solution

by:
Vitor Montalvão earned 500 total points
ID: 40616915
Because Standard Edition always support FCI since SQL Server 2005. The only limitation is the 2 nodes. For Enterprise Edition there's no nodes limitation.

The real AlwaysOn solution (Availability Groups) that is available since SQL Server 2012 it's an Enterprise Edition feature.
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi Everyone Now IIS AppPool issues is something we have always had because of the amazing custom development and in-house applications we have :) The issues we had were getting out of control and it was time to do something about it, just for…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question