Enable to restore the database from automated backups for MySQL flexible DB server

Question

Enable to restore the database from automated backups for MySQL flexible DB server

Punit katnalli 25

While restoring the backups from MySQL Flexible DB server we are getting the below error

Trying to restore the backup from Mumbai region to EastUS region.

{"code":"InternalServerError","message":"An unexpected error occured while processing the request. Tracking ID: 'aa3b7af4-c295-4444-952a-7d4a0b577496'"}

Mahesh Kurva 6,850 Reputation points Microsoft External Staff Moderator

2025-07-26T00:22:23.97+00:00
Hi Punit katnalli ,Greetings!!

As i understand that when you attempt to restore an Azure Database for MySQL Flexible Server backup from one region (Mumbai) to another (East US), and you receive a error:

If geo-redundant backups were not enabled on the source server, restoring to another region (like East US) will not be possible.

However, the InternalServerError you're encountering may be due to SKU unavailability or capacity limitations in the East US region.

To verify this, please run the following Azure CLI command to check which SKUs are currently available in East US:

az mysql flexible-server list-skus --location eastus --output table

If your desired SKU isn't listed, we recommend:

Trying a different SKU or compute tier.

Attempting the restore in an alternate region that may have available capacity.

For more information, please refer the document:

Backup and restore in Azure Database for MySQL.

Resolve capacity errors for Azure Database for MySQL.

I hope this information helps. Please do let us know if you have any further queries.

3 answers

Your answer

Mahesh Kurva 6,850 Reputation points Microsoft External Staff Moderator

2025-07-26T00:22:23.97+00:00

Hi Punit katnalli ,Greetings!!

As i understand that when you attempt to restore an Azure Database for MySQL Flexible Server backup from one region (Mumbai) to another (East US), and you receive a error:

If geo-redundant backups were not enabled on the source server, restoring to another region (like East US) will not be possible.

However, the InternalServerError you're encountering may be due to SKU unavailability or capacity limitations in the East US region.

To verify this, please run the following Azure CLI command to check which SKUs are currently available in East US:

az mysql flexible-server list-skus --location eastus --output table

If your desired SKU isn't listed, we recommend:

Trying a different SKU or compute tier.

Attempting the restore in an alternate region that may have available capacity.

For more information, please refer the document:

Backup and restore in Azure Database for MySQL.

Resolve capacity errors for Azure Database for MySQL.

I hope this information helps. Please do let us know if you have any further queries.

Answer 1

Punit katnalli 25

Hi Mahesh Kurva

We have already enabled the geo-redundant backups for the database, With that we tried to restore the backup into different region and we were not able to the deployment took nearly 40 minutes and ended up giving the error -

{"code":"InternalServerError","message":"An unexpected error occurred while processing the request. Tracking ID: 'aa3b7af4-c295-4444-952a-7d4a0b577496'"}

If this was the issue with SKU, We have tried to restore the backup again in different time during that time we were able to restore the database withing 10 minutes. As this has caused the critical down time unavailability of the ENV, We want a RCA for the above issue as we tried with different time we were able to restore. FYR - We have tried the above cmd which was provided to check the SKU per region and we getting the below output.

User's image

Mahesh Kurva 6,850 Reputation points Microsoft External Staff Moderator

2025-07-28T09:05:47.62+00:00

Hi Punit katnalli,

Please share the requested details in private message for further investigation.
Mahesh Kurva 6,850 Reputation points Microsoft External Staff Moderator

2025-07-29T16:54:19.9533333+00:00

Hi Punit katnalli,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

Answer 2

Punit katnalli 25

Hi Mahesh Kurva

I am following up, If you got time to check for the above query.

Thanks.

Mahesh Kurva 6,850 Reputation points Microsoft External Staff Moderator

2025-07-30T11:41:28.4833333+00:00

Hi Punit katnalli,

Please share the requested details in private message for further investigation.

Answer 3

Punit katnalli 25

Hi Mahesh Kurva

I am following up, If you got time to check for the above query.

Mahesh Kurva 6,850 Reputation points Microsoft External Staff Moderator

2025-08-01T04:55:21.9833333+00:00

Hi Punit katnalli,

We got an update that internal team have enabled geo backup again, pls have a try and let us know the result

Share via

Enable to restore the database from automated backups for MySQL flexible DB server

3 answers

Your answer