@Rifka Khairani Thank you for reaching out.
Duplicate question.
Please see my answer here https://learn.microsoft.com/en-us/answers/questions/1336239/how-invoke-azsqldatabasefailover-command-works?orderby=helpful#answers
Regards,
Oury
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi, I have some questions regarding Azure SQL database high availability.
What is the difference between executing Invoke-AzSqlDatabaseFailover command on an Azure SQL database that has zone redundancy enabled and not? I have two Azure SQL databases on the same logical server with general purpose service tier. I enabled the zone redundant option on one of the databases, then executing manually the command Invoke-AzSqlDatabaseFailover on the database, which returned success. After that, I executed the same command on the other database that has zone redundant disabled, and it returned success too. Does the latter support failover on the same region since it has local redundant availability by default?
Also, I am curious if it is possible to identify the region of an Azure SQL database after manually executing failover on a database with zone redundancy enabled. Thank you for your help.
Thank you for your help
@Rifka Khairani Thank you for reaching out.
Duplicate question.
Please see my answer here https://learn.microsoft.com/en-us/answers/questions/1336239/how-invoke-azsqldatabasefailover-command-works?orderby=helpful#answers
Regards,
Oury