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
Loading
Automatic failover for an Azure SQL DB
1 Answer
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.
Jay PankhaniyaPosted Mar 8, 2023, 2:09 AM