Questions tagged [failover-cluster-instance]
34 questions
2
votes
1 answer
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 around, I noticed some people believe this is…
Fajela Tajkiya
- 1,239
- 9
- 23
2
votes
0 answers
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 for 1 week to ensure no patch related…
variable
- 3,590
- 4
- 37
- 100
1
vote
1 answer
SQL Availability Group and File Server Role Using the Same DNS Name
I'm tasked with setting up a 2 node cluster that will host a MS SQL availability group. I have the servers setup and the AG looks to be working as expected. However, there is another requirement to hang a file share off one of the drives. I'm not…
user30045359
- 11
- 1
1
vote
1 answer
Oracle RAC 19c instance fails to start with ORA-29707: inconsistent value 1 for initialization parameter 1146 with other instances
After having to restart a node in a RAC cluster, we ran into "ORA-29707: inconsistent value 1 for initialization parameter 1146 with other instances" when trying to use srvctl start instance -i ORAPD3 -d ORAPD.
CMD output was something…
jmichaelwDBA
- 51
- 6
1
vote
0 answers
Machine Learning Services fails from Secondary Node of SQL Failover Cluster Instance
There was a planned cluster failover to the secondary node of our FCI. Afterwards, sp_execute_external_script stopped working.
Examples with error messages are below:
EXEC sp_execute_external_script…
Dave Mason
- 875
- 1
- 8
- 19
1
vote
2 answers
Failover time after SQL Server patch
We have two node Windows Server cluster with installed SQL Server (2019 Standard Edition) Clustered instances on each node
There are 500 active databases
There are no any Availability Groups or any other HA solutions configured
All databases are on…
Elvin Ahmadov
- 240
- 1
- 8
1
vote
1 answer
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 maintains a synchronized copy of the
configuration…
variable
- 3,590
- 4
- 37
- 100
1
vote
1 answer
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 attached to the failed node, but I cannot find out…
Rauf Asadov
- 1,313
- 14
- 36
0
votes
0 answers
MariaDB Galera nodes rejoining but missing data after resync
I have 1 MariaDB Galera cluster composed of 5 nodes in 2 different datacenters: 3 in DC1, 2 in DC2, On DC1, one of the nodes has a pc.weight=2. Bootstrap was set on Node 1 from DC1.
Data between the 5 nodes is correctly synced and system works…
scharrua
- 11
- 2
0
votes
1 answer
SQL Server Failover Cluster Data Loss on failover
Currently running several databases on an Active/Passive SQL Server 2014 Failover Cluster on Windows Server 2012 R2. Recently there was an event that caused the active server to failover. The failover was just a quick moment.
The problem is when the…
0
votes
1 answer
What is best practice when performing manual failover in a 2 node FCI
Using SQL Server 2019 with 200+ databases in a 2 node FCI, what is considered best practice regarding SQL Server Agent when performing manual failover for SQL Server CU patching. Should we manually stop the SQL Server Agent before failover?
I ask…
H. Engmark
- 1
- 1
0
votes
1 answer
Will a 2-node windows server failover cluster go down if the disk witness owner crashes?
In a 2 node WSFC where Node 1 owns the disk witness, would Node 1 crashing result in the entire cluster going down (loss of quorum because only 1/3 votes remain)?
Or does disk witness ownership transfer to Node 2 regardless of whether Node 1 was…
Marcus
- 89
- 7
0
votes
2 answers
What is a difference in failover time for SQL Server FCI when database is in Full vs Simple recovery mode
I have 2-node SQL Server 2019 FCI cluster, which takes up to 4 minutes to failover from one node to another.
The cluster has 3 user databases, migrated from the older SQL server versions:
2 databases with higher load have SIMPLE recovery model (and…
Sergey Nudnov
- 103
- 2
0
votes
1 answer
Configuring a Failover Cluster Fileshare Witness?
I'm relatively new to high availability groups in SQL Server, and am hoping for a bit of advice on best practices for configuration. I didn't set up this configuration, I inherited it and am trying to get an understanding as I've been moved towards…
fuandon
- 101
- 3
0
votes
1 answer
It's possible switchover a innodb cluster instance as primary?
If I am in topologyMode Single-Primary, it's possible to switchover the primary instance between machines in the cluster? I did not find anything in the documentation.
Ie: in my lab I have:
topology": {
"mysql0:3306": {
…
Astora
- 841
- 5
- 28
- 64