Difference between AG && FCI

Question

Difference between AG && FCI

joujousagem2006 1602

SSCommitted

Points: 1779
More actions
September 23, 2018 at 7:38 am

#368804

Hi,
what is the difference between AlwaysOn availability groups and AlwaysOn Failover cluster instances
thanks

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

andreas.kreuzberg SSCertifiable Points: 6191 More actions · Answer 1

Hi,
difficult, but I try to explain:

AlwaysOn Failover cluster instances
If a failover occurs, the instance did a failover
All objects are on the new instance, jobs, logins, etc.

AlwaysOn availability groups
If a failover occours, the databases did a failover
the admin had to take care, that all required objects, like logins, jobs are "replicated" to the new instance

Kind regards,
Andreas

VastSQL SSC-Dedicated Points: 36097 More actions · Answer 2

joujousagem2006 1602 - Sunday, September 23, 2018 7:38 AM
Hi,
what is the difference between AlwaysOn availability groups and AlwaysOn Failover cluster instances
thanks

There is Failover Cluster and Always On Availability Group.

In brief Availability group is a HADR solution for specific database and the databases can be read mode ,means you are using the resources of that server for Read purpose also can offload backup. When you do failover in Availability Group you do it for the databases involved in availability group , where as for FC you do for the whole instance and the resource of secondary is not used for Active\Passive setup .

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/failover-clustering-and-always-on-availability-groups-sql-server?view=sql-server-2017

http://www.sqlservercentral.com/blogs/sql-server-overview/2018/01/13/alwayson-availability-groups-vs-alwayson-failover-cluster-instances/

Perry Whittle SSC Guru Points: 234013 More actions · Answer 3

joujousagem2006 1602 - Sunday, September 23, 2018 7:38 AM
Hi,
what is the difference between AlwaysOn availability groups and AlwaysOn Failover cluster instances
thanks

please see my stairway at this link

http://www.sqlservercentral.com/stairway/112556/

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉