Questions tagged [failover-cluster-instance]

Filter by
Sorted by
Tagged with
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 ...
user avatar
  • 2,367
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 ...
user avatar
  • 1,007
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 ...
user avatar
  • 1,163
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 ...
user avatar
  • 1,007
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 13
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 ...
user avatar
  • 231