Problem Description:
Azure SQL backup is failing with an error code AZURE_SQL1022
Traceback
azsqlioserver.log
error: Internal error failed to handle keyvault: failed to get key from keyvault
Cause:
This error occurs when the Azure Key Vault is not reachable due to missing firewall rules in the associated Virtual Network (VNet) used by Quantum Bridge.
Resolution:
Add the required firewall rules in the associated VNet where the Quantum bridge is deployed to allow access to the following service:
Azure Key Vault
URL Format:https://pdcp-drv-<Siteid>-<Subscriptionid>.vault.azure.net/
Once the rules were updated, the backup job successfully retrieved the key from Key Vault and completed without errors.
Verification:
Trigger a manual backup from the console.
Verify the job status transitions from Queued to Running and finally Successful.