Not possible to restore MySQL databases using the "Restore to cross region" and select a "Point-in-time-restore (PITR)"

Question

I can't restore a Azure MySQL database backup (East US), I get the deployment error:

Provisioning is restricted in this region. Please choose a different region. For exceptions to this rule please open a support request with Issue type of 'Service and subscription limits'.

(Code: ProvisioningDisabled)

I'm able to restore the MySQL database using the "Restore to cross region" option but when that option is enabled I'm not able to select a "Point-in-time-restore (PITR)" which is kind of useless because apparently it selects the latest backup which in my case is already corrupted, so I need an option to use the "Restore to cross region" option while also being able to select a "Point-in-time-restore (PITR)"

I'm amazed that this is not actually the case, what's the point of storing a week worth of backups if I can only select the last one

Answer 1

Hi Paulo,

Please carefully follow my instructions below to create a new Service and subscription limits (quotas) request to allow access to deploy Azure Database for MySQL Flexible Server in East US. Assuming they approve your request, you will be able to restore.

1. Navigate to this link to start the process:

https://portal.azure.com/#view/Microsoft_Azure_Support/HelpAndSupportBlade/~/overview

2. Click Create a support request button at top

3. If you see Support AI Assistant as shown below, click Switch to old experience button on right. Otherwise, proceed to step #4

4. Enter quota in the box and click Go

5. Select Others / Service and subscription limits (quotas) and click Next

6. Click Create a support request button, as shown

7. Select Issue type: Service and subscription limits (quotas), Subscription, Quota type: Azure Database for MySQL Flexible Server, click Next

8. Now you should be on Additional details tab. Click Enter details

9. Select Region access or Region access with zonal dependency, select Location you need, enter number of cores needed (you may need higher than screenshot), click Save and continue

10. Finish filling out Additional details tab, click Next, review and click Create. You should receive an automated email within a few minutes.

If they deny your request, I recommend explaining to them that it is emergency since you need it to restore your database.

Please click Accept Answer and upvote if the above was helpful.

Thanks.

-TP

Answer 2

Hi Paulo ,

Greetings!!

The reason you're unable to perform a Point-in-Time Restore (PITR) to an earlier backup in another region is due to a limitation in how Azure Database for MySQL – Flexible Server handles backups:

• PITR is only available in the same region as the original server because the transaction logs needed for PITR are not replicated cross-region.
• The "Restore to cross region" option uses only the latest full backup and does not support selecting a specific timestamp, which is why you're unable to restore to an earlier point before the corruption occurred.
• Since the East US region is currently under provisioning restriction, PITR is not available until provisioning is allowed again in that region.

Since East US is restricted, open a support ticket:

• Go to Azure Portal → Help + Support → Create a support request
• Use Issue type: “Service and subscription limits”
• Request provisioning access in East US for restore purposes.

For more information, please refer the document: https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-backup-restore?wt.mc_id=knowledgesearch_inproduct_azure-cxp-community-insider

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