Read Replica for DR with Failback

Hi,

I have been experimenting with Azure MySQL Flexible Server Read Replica as a DR scenario and it works really well. The manual failover process is successful.

However, I am now trying to configure a failback scenario whereby I reconfigure the now standalone MySQL Read Replica server in the DR region to enable geo-redundant backup storage and then I try to initiate a Universal Geo Restore of this server to a different Azure region.

The Geo Restore operation fails with the following error :

"The resource operation completed with terminal provisioning state 'Failed'"

The MySQL Flexible servers (source and Read Replica) are configured for Private Networking (VNet Integration not Private Endpoint) and the Virtual Networks are peered. They both use the same Private DNS Zone which is linked to both VNets as well.

It feels like this *should* work but I can't figure out why it is failing. 

If anyone has any insight it would be appreciated. 

Regards,

Paul Lynch