Solved

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

Posted on 2015-02-17
8
621 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 46

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
 
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
Will my email signature work in Office 365?

You've built an email signature using raw HTML code in Office 365, but you can't review how it looks with Transport Rules. So you have to test it over and over again before it can be used. Isn't this a bit of a waste of your time? Wouldn't a WYSIWYG editor make it a lot easier?

 
LVL 46

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 46

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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Wow it feels like forever since I have been able to sit down and write an article, I have been away and new exciting projects keeping me busy, but here I am writing another hopefully informative article. I have written about Orchestrator 2012 int…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

914 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now