How Invoke-AzSqlDatabaseFailover command works

Rifka Khairani 40 Reputation points
2023-07-24T13:23:32.75+00:00

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

Azure SQL Database
0 comments No comments
{count} votes

Accepted answer
  1. Oury Ba-MSFT 20,186 Reputation points Microsoft Employee
    2023-07-24T21:14:44.0233333+00:00

    @Rifka Khairani Thank you for reaching out.

    My understanding is that you have 2 azure SQL Databases created on the same logical server with general purpose service tier. Running the Invoke-AzSqlDatabaseFailover PowerShell command on an Azure SQL database returned success on both Databases with zone redundant enabled and disabled (with locally redundant).

    The command Invoke-AzSqlDatabaseFailover induces fault for SQL database and helps us to witness resiliency in action. If executed against a non-zone redundant database, the database would be brought online from any datacenter within a region. If executed on a zone redundant database, the database would be brought online from a different zone than the current one.

    Regarding your second question, after manually executing failover on an Azure SQL database with zone redundancy enabled. You cannot see zone number or region for a zone redundant database. It is something that is automatically taken care. We do plan to expose the info in future, but we don't have any ETA yet.

    Hope that clarifies your ask.

    Regards,

    Oury

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.