Sample Header Ad - 728x90

Why choose SQL FCI over Database Mirroring

0 votes
2 answers
251 views
I have SQL 2016 **Standard** Edition to install and configure a HA/DR solution. I need automatic failover in a cluster of two nodes. I am proposing SQL FCI over database Mirroring for the following reasons: - FCI will need only two nodes for the configuration and will failover automatically - Database Mirroring is being phased out by Microsoft and moreover, in order to achieve automatic failover, we will need an extra server (for witness) in addition to the two nodes of the cluster. Hence requiring 3 difference SQL instances in 3 VMs. Would you agree with my reasoning and are there any other things I need to consider please? Automatic failover is essential in the requirements. Thank you.
Asked by PTL_SQL (427 rep)
Jun 8, 2021, 12:42 AM
Last activity: May 28, 2025, 06:08 AM