Point In Time Restore fails

Nakazawa 0

I'm trying to deploy an Azure Database for MySQL flexible server from Point In Time backup source and it always fails with "Conflict" status. I've tried different server sizes (more vCPUs) and different backup points (different hour/days) and it didn't solve my problem. How can I manage to do Point-In-Time Restore successfully?

1 answer

ShaktiSingh-MSFT 15,341 Reputation points

2024-07-22T06:00:17.2466667+00:00

Hi Nakazawa •,

Welcome to Microsoft Q&A forum.

As I understand, you are trying to deploy an Azure Database for MySQL flexible server from Point In Time backup source and it always fails with "Conflict" status.

In Azure Database for MySQL flexible server, performing a point-in-time restore creates a new server from the flexible server's backups in the same region as your source server.

Could you please check the Region of the original server?

It's created with the original server's configuration for the compute tier, number of vCores, storage size, backup retention period, and backup redundancy option. Also, tags and settings such as virtual network and firewall are inherited from the source server. The restored server's compute and storage tier, configuration and security settings can be changed after the restore is completed.

Check server name which you give for the new one.

Ensure that network configurations (e.g., VNet, subnet) are correctly set up and that there are no conflicts.

Follow this https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-restore-server-portal for in case you are using restore to move a server from Public access to Private access.

Let us know your finding.

Awaiting your reply.

Thanks
Please sign in to rate this answer.

1 person found this answer helpful.
Nakazawa 0 Reputation points

2024-07-22T09:23:57.9733333+00:00

Hello ShaktiSingh,

In Azure Database for MySQL flexible server, performing a point-in-time restore creates a new server from the flexible server's backups in the same region as your source server.

Yes, that's exactly what I'm trying. I'd like to create a new temporary server from a point-in-time restore source so I can salvage some records from a certain table while I keep the original database unchanged.

Could you please check the Region of the original server?

The region of both the original and the new server is Japan East .

It's created with the original server's configuration for the compute tier, number of vCores, storage size, backup retention period, and backup redundancy option. Also, tags and settings such as virtual network and firewall are inherited from the source server. The restored server's compute and storage tier, configuration and security settings can be changed after the restore is completed. Check server name which you give for the new one. Ensure that network configurations (e.g., VNet, subnet) are correctly set up and that there are no conflicts.

Oops, then it must be a conflict of the public endpoint because the original server allows traffic from whitelisted IPs. I'll try it again with a correct network configuration w/o conflict.

Thanks,

ShaktiSingh-MSFT 15,341 Reputation points

2024-07-24T08:40:05.2666667+00:00

Thanks for the reply.

Let us know when you try and able to make it.

Just checking in to see if the provided suggestion helped. If this answers your query, do click Accept Answer and Mark Helpful for the same. And, if you have any further query do let us know.

Thanks

Nakazawa 0 Reputation points

2024-07-31T02:01:07.27+00:00

I was keep getting the conflict error even though I tried different network configurations which wouldn't conflict with any other resources/servers.

But, I appreciate your kind help.

ShaktiSingh-MSFT 15,341 Reputation points

2024-08-01T07:44:59.2866667+00:00

Hi Nakazawa •,

Thanks for coming back with you reply.

This is strange and not expected. I would recommend you to please file a support ticket for deeper investigation and in case if you don't have a support plan, do let us know here so that we can check on other options to unblock you.

Thanks
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Point In Time Restore fails

1 answer

Your answer