Questions tagged [failover-cluster-instance]
The failover-cluster-instance tag has no usage guidance.
8
questions
0
votes
1
answer
26
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 ...
0
votes
2
answers
32
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
vote
1
answer
42
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 ...
0
votes
1
answer
88
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 ...
0
votes
0
answers
28
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
35
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
71
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 ...
0
votes
1
answer
67
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 ...