Resource is not available to restore DB backup in azure

Question

Hi Team,

Azure DB scheduled backup is stuck and Unable to restore DB backup as resorce is not available.

Please do the needful

Answer 1

Hi @Roopa V

At times, either random failures may happen in backup and restore operations or those operations might get stuck. This may be because of antivirus programs on your VM. As a best practice, we suggest the following steps:

Exclude the following folders from antivirus scanning:

C:\Program Files\Azure Workload Backup C:\WindowsAzure\Logs\Plugins\Microsoft.Azure.RecoveryServices.WorkloadBackup.AzureBackupWindowsWorkload

Replace C:\ with the letter of your SystemDrive.

Exclude the following three processes running within a VM from antivirus scanning:

• IaasWLPluginSvc.exe
• IaaSWorkloadCoordinatorService.exe
• TriggerExtensionJob.exe

SQL also offers some guidelines about to work with antivirus programs. See this article for details.

You can restore to a SQL VM only if all the SQL instances running within the VM are reported healthy. If one or more instances are "faulty", the VM won't appear as a restore target. So this could be a possible reason why a multi-instance VM may not appear in the "server" dropdown during the restore operation.

Please go through this Documentation that might help you:

https://learn.microsoft.com/en-us/azure/backup/backup-sql-server-azure-troubleshoot#troubleshoot-backup-and-recovery-issues

Hope this helps. Do let us know if you any further queries.

---

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.