September 3, 2019 at 12:29 pm
I confuse these two terms and can't understand the difference between them. Are they the same, part of one another, or somehow related?
I know about WSFC and SQL Server Clustering on it, but can't understand how FCI is different?
September 3, 2019 at 3:58 pm
I suppose the best way to think about it, WSFC is at the operating system level, and FCI is at the SQL Server level. You can have WSFC without FCI, but you can't have FCI without WSFC:
September 4, 2019 at 5:44 am
Thanks, I understand that part. What is the difference between SQL Server Failover Cluster and SQL Server Failover Clustering Instance?
Does instance mean one node of SQL Server Cluster, or are these completely different technologies. Maybe I confuse terms
one is Always on FCI
and the other this
Are they the same?
September 15, 2019 at 5:45 pm
Thanks, I understand that part. What is the difference between SQL Server Failover Cluster and SQL Server Failover Clustering Instance?
Does instance mean one node of SQL Server Cluster, or are these completely different technologies. Maybe I confuse terms
one is Always on FCI
and the other this
Are they the same?
These two articles you list are about the same technology.
September 18, 2019 at 6:36 pm
Think about this. You have multiple instances on a machine. Let's say you need to do some sort of maintenance to one, but not all of the instances. You can fail over just one of the instances to the other server, but leave all the other instances alone. This is FCI. Now, the other, WSFC, would be at the OS or server level. A kernal failure or somebody (virtually, perhaps) trips over the plug. You would want all of the instances to fail over to the other node.
This can also be true for single instances. It just depends on what level you want the control. Instance or server.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply