We are planning to deploy a 4-node SQL Failover Cluster Instance. Is it possible to deploy 4 node SQL FCI (not Always on availability group) using SQL Standard edition license?
We are planning to deploy a 4-node SQL Failover Cluster Instance. Is it possible to deploy 4 node SQL FCI (not Always on availability group) using SQL Standard edition license?
Hi @RonyPaul-9719 ,
We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
Hi @RonyPaul-9719,
Just checking in to see if above information was helpful. If you have any further updates on this issue, please feel free to post back. If you think my reply is helpful to you, please remember to mark it as an answer. Warm thanks.
Best regards,
Seeya
Good day ,
Check this document please:
and here is the quote for the Always On failover cluster instances:
On Enterprise Edition, the number of nodes is the operating system maximum. On Standard edition there is support for two nodes.
By the way, Always On availability groups is not supported in Standard edition so there was no need for the (not Always on availability group) but if you need then you can use Basic availability groups (a bit different feature for Standard edition
Hi @pituach
Thanks for the reply.
If we purchase SQL Standard edition license with Software Assurance, can we BE able deploy 4 node SQL Cluster FCI?
I have gone through the link you provided and found that Software assurance needed for Failover servers for disaster recovery, Failover servers for high availability.
Hi,
If we purchase SQL Standard edition license with Software Assurance, can we BE able deploy 4 node SQL Cluster FCI?
No!
I thought that the quote I gave you clarify this :-)
Using On Standard edition there is support for two nodes only
Hey,
As mentioned, on Standard edition FCI is limited for 2 nodes. To deploy a 4 node SQL FCI you will need Enterprise edition. With Standard edition you have 2 options either SQL FCI or Basic Availability Groups. Check the following comparison:
https://www.starwindsoftware.com/resource-library/sql-server-failover-cluster-instance-vs-basic-availability-group/
Cheers,
Alex Bykovskyi
StarWind Software
Note: Posts are provided “AS IS” without warranty of any kind, either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose
Hi @RonyPaul-9719,
Agree with them.
Please see: The Limitations of Basic Always On availability groups for a single database.
Best regards,
Seeya
If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
14 people are following this question.