Solved

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

Posted on 2015-02-17
8
1,000 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 50

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
Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

 
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 50

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 50

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

Suggested Solutions

Title # Comments Views Activity
Load Fact table in SQL Server SSIS package 14 47
HIghlights of SSIS? 3 45
SQL: Default Database Integrity Jobs Failing 6 27
domain controller shut down question 6 70
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This process describes the steps required to Import and Export data from and to .pst files using Exchange 2010. We can use these steps to export data from a user to a .pst file, import data back to the same or a different user, or even import data t…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

752 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