Share via


Add support for MultiSubnetFailover

Enabled for Public preview General availability
Users, automatically - Apr 1, 2025

Business value

For on-premises customers who run the database with high availability features, failover operations are faster. This improvement reduces downtime during failovers and makes the system more available for users.

Feature details

The MultiSubnetFailover feature enables faster failover for all Availability Groups (AGs) or Failover Cluster Instances (FCIs) in SQL Server 2012 or later versions. This feature significantly reduces failover time for single-subnet and multi-subnet Always On topologies.

In this release wave, we added a new server setting, EnableSqlMultiSubnetFailover. When an administrator sets this value to true, the server enables the MultiSubnetFailover feature on connections from the server to the database. When you enable this setting, the system ensures faster failover operations for databases with high availability features. Users benefit from improved system availability.

For more information about the MultiSubnetFailover feature in SQL Server 2012, see SQL Server Multi-Subnet Clustering.

Diagram of how MultiSubnetFailover works

Geographic areas

Visit the Explore Feature Geography report for Microsoft Azure areas where this feature is planned or available.

Language availability

Visit the Explore Feature Language report for information on this feature's availability.

Tell us what you think

Help us improve Dynamics 365 Business Central by discussing ideas, providing suggestions, and giving feedback. Use the forum at https://aka.ms/bcideas.

Additional resources

Database settings (docs)