Tuhin Paul
Automatic failover for an Azure SQL DB

Can you configure an automatic failover for an Azure SQL DB with a Basic service tier?
A. Yes, automatic failover is supported for all service tiers
B. No, automatic failover is not supported for Basic service tier

By Tuhin Paul in Azure on Feb 22 2023
  • Jay Pankhaniya
    Mar, 2023 8

    B. No, automatic failover is not supported for Basic service tier.

    Azure SQL DB Basic service tier does not support automatic failover. Automatic failover is supported only for Standard, Premium, and Business Critical service tiers. In the Basic service tier, you can perform manual failover to a secondary replica in case of a planned maintenance event or a disaster that affects the primary replica.

    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS