Questions tagged [failover-cluster-instance]

Filter by
Sorted by
Tagged with
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 ...
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 ...
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 ...
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 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