Questions tagged [failover-cluster-instance]
The failover-cluster-instance tag has no usage guidance.
22
questions
2
votes
1
answer
39
views
Should the quorum drive always be at the same node with the SQL Server role in a SQL Server failover cluster environment?
In a SQL Server failover cluster environment, I can move the SQL Server role to node a and the quorum drive at node b. Although it's possible, is this a correct configuration? While I was Googling ...
- 735
0
votes
1
answer
79
views
Is anyone aware of issues where uninstalling SQL 2012 Native Client has broken Failover Clustering?
We were recently asked to remove unsupported software from our servers and the list included SQL 2012 Native Client. Version 11 was installed, so we removed it from test & dev servers without any ...
- 13
0
votes
1
answer
69
views
Is it not possible to add instance and shared features to a pre-existing FCI?
I'm looking at a sql server fci that has the database engine installed. My task is to add the full text search service and integration services.
I'm exploring how to do this when I came across this ...
- 3,106
0
votes
1
answer
46
views
What is the use case difference between forced quorum and force cluster to start without quorum?
I'm learning about handling fci issues and stuck at 2 concepts to recover from cluster failure:
Forced quorum
Force start without quorum
What is the factor to decide whether to use which of the ...
- 3,106
-1
votes
1
answer
59
views
What does `same WSFC cluster can run multiple FCIs (multiple resource groups)` mean?
Link: https://learn.microsoft.com/en-us/sql/sql-server/failover-clusters/windows/always-on-failover-cluster-instances-sql-server?view=sql-server-ver15#FCIelements
the same WSFC cluster can run ...
- 3,106
2
votes
0
answers
24
views
Does sql config manager changes (example: service account) on 1 FCI node auto update it onto the other node?
Link: https://learn.microsoft.com/en-us/sql/sql-server/failover-clusters/windows/always-on-failover-cluster-instances-sql-server?view=sql-server-ver15#FCIelements
Each node in the resource group ...
- 3,106
2
votes
0
answers
19
views
What is the approach to handle failover and compatibility issues when patching FCI nodes?
I have FCI with 2 nodes.
Following is steps to patch the nodes:
Remove node from Possible owners
Patch the inactive node
Add the node to the Possible owners
Failover to inactive node
Leave it running ...
- 3,106
0
votes
1
answer
28
views
Catch-22 Errors in Configure Replication Wizard on a Failover Cluster Named Instance
I'm attempting to setup replication on a new SQL 2019 install but I'm encountering a catch-22 in errors.
I have two (2) named instances setup side by side, each setup as a cluster role. The cluster ...
0
votes
1
answer
475
views
This operation returned because the timeout period expired - unable to add third node to existing Windows Failover Cluster
I have a Windows failover cluster up and running, with two nodes.
I'm now trying to add a third node:
Add-ClusterNode -Name node3
this unfortunately fails with the following error:
The clustered ...
- 103
-1
votes
1
answer
136
views
Cluster Resource fails every 8 hours for SQL AG
Every ~8 hours, I receive the error below in my Windows Cluster events. During this same time connections to SQL server are being lost. I am struggling to find any resources that help determine what ...
- 571
0
votes
2
answers
326
views
SQL Server 2019 DAG WFC - Manual Failover won't work (MSSQL Error 41131)
We set up a distributed failover cluster with 2 Windows Server 2019 Datacenter nodes, each of them running SQL Server 2019 Enterprise + SSMS18.
The two nodes are located in two different sites with ...
- 1
-1
votes
2
answers
139
views
Does Availability Group between 2 failover cluster instances require a 4 node WSFC cluster?
I have 2 SQL Server Failover Clustering Instances (FCI). Each FCI consists of a 2-node Windows Server Failover Cluster.
I want to setup an Availability Group between the 2 FCIs.
One of the ...
- 3,106
-3
votes
1
answer
55
views
What does FCI owners in a WSFC mean and how does it prevent adding replica to same WSFC?
Link: https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/prereqs-restrictions-recommendations-always-on-availability?view=sql-server-ver16#RestrictionsFCI
The cluster ...
- 3,106
-2
votes
1
answer
139
views
Which nodes are active in a multi-subnet failover cluster?
I have previously worked with FCI where there are 2 nodes. 1 server is active and other service is not active. Both share the same disk. If node 1 or sql server service on node 1 goes down, then it ...
- 3,106
0
votes
1
answer
46
views
Why does FCI not have worry of split brain scenario?
SQL server AG has lease time-out to ensure there will never be a split brain scenario.
Where as there is no such thing for FCI.
Both AG and FCI (HA) require the windows failover cluster, but why does ...
- 3,106
0
votes
2
answers
88
views
Failing over to DR site Availability group
I have a 4 node cluster SQL 2012 availability group database with one witness server at the primary site. 3 nodes are in the primary site and one node in the DR site.
Due to maintenance at the Primary ...
- 1,007
1
vote
1
answer
225
views
Why automatic failover does not occur when I turn off SQL Service in SQL Server Failover Cluster Instance?
I faced unusual behavior associated with automatic failover so that automatic failover does not work in the case of turning off SQL Server service. It seems that clustered disks are still remaining ...
- 1,203
0
votes
1
answer
298
views
File Share Witness location
We have a 4 node availability group with 3 node on the primary data center and one node on the secondary data center.
We want to add a file share witness and since we dont have a third data center and ...
- 1,007
0
votes
0
answers
41
views
Procedures to safely perform SQL Server Always On database cluster failover during Updates & Patching?
I need some steps and guidance, to perform the Microsoft Cluster Failover (MSCS 2016) for my SQL Server 2017 Enterprise Edition – Always-On 2x nodes.
This is to perform the Windows Server updates that ...
0
votes
0
answers
75
views
Error message when Selecting Replication | Distribution Configuration
We have a SQL Server 19 installation configured for Failover Cluster Instance. I have been asked to setup replication between two databases on this server. When following the Microsoft documentation ...
0
votes
1
answer
174
views
Create availability group between FCI and standalone node
first question here so please advise if I've missed anything.
I've read this question (AG of 2 replicas on 2 nodes in WSFC : is it possible to add 3rd replica to AG and NOT add 3rd machine WSFC?
) but ...
- 13
0
votes
1
answer
81
views
Troubleshoot SQL FCI
I have just installed a Failover Cluster Instance (FCI) which was running ok. I then had to change the service accounts that the services were using and for some reason that I haven't been able to ...
- 237