Azure BAckup for SQL server Configuration Failing with CloudInternalError

venkatesh tanjore 1

Hi
we have SQL Server databases on Azure VM's. we have scheduled VM backup weekly basis using Azure Backup. Now we are trying to setup Azure Backup for SQL to take daily backup of databases. but when we try to enable backup on database using the steps mentioned in azure backup documentation, the deployment fails with internal error and status as Conflict

i see following error in json response when its trying to deploy
"resourceId": "/subscriptions/3fdd3bb1-0259-4b3b-a1f3-f80ab56bd6ec/resourcegroups/CISACORE-PROD-EAST2-RECOVERYVAULT-RG/providers/Microsoft.RecoveryServices/vaults/VM-BACKUP-RSV/backupFabrics/Azure/protectionContainers/vmappcontainer;compute;cisacore-prod-east2-securitytools-rg;tan-dbsrvr-02/protectedItems/sqldatabase;mysqlsrvr;mydb

statusMessage": "{\"status\":\"Failed\",\"error\":{\"code\":\"ResourceOperationFailure\",\"message\":\"The resource operation completed with terminal provisioning state 'Failed'.\",\"details\":[{\"code\":\"CloudInternalError\",\"message\":\"Microsoft Azure Backup encountered an internal error.\"}]}}",

Not sure what is issue. also i am not sure is it because VM Level backup already exists and its not able to deploy DB backup.. i checked all the prereq's as per documentation and its looking good.

any idea what is going wrong

SadiqhAhmed-MSFT 38,081 Reputation points Microsoft Employee

2021-01-19T18:24:23.117+00:00

@venkatesh tanjore Apologies for delay in response to your query.

The error ""The resource operation completed with terminal provisioning state 'Failed" is generic in nature and the reason for failure could be anything, To list a few:

Firewall or proxy issue
May be some database files are corrupted or blocked
Could be some encryption issue

To better understand the root cause, we need to perform deeper investigation and that is only possible through Azure technical channel. You can contact Azure technical support team by raising a technical support request using this - https://learn.microsoft.com/en-us/azure/azure-portal/supportability/how-to-create-azure-support-request

Let me know if there are any challenges creating a support ticket.