Skip to main content

Azure SQL backup is failing with an error code AZURE_SQL1022

Azure SQL backup is failing with an error code AZURE_SQL1022

Updated this week

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.

Did this answer your question?