Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2015-02-17
8
Medium Priority
?
1,305 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 52

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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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 52

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 52

Accepted Solution

by:
Vitor Montalvão earned 2000 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

722 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