SQL in Azure VM backup jobs no longer listed in the Jobs nor in Backup Center (Preview)

Christian van der Geer 1 Reputation point
2021-02-11T09:46:09.87+00:00

We have backup jobs for Azure virtual machines as well as jobs for SQL in Azure VM backup.
In the Backup jobs we see the completed jobs for Azure Virtual Machines, but we do not see jobs for the SQL jobs (last mention of the SQL jobs are of 9the of Feb 2021).
Under the Backup Items I can see that the SQL backups have been ran successfully.

Also the (preview) Backup Center shows 0 jobs for the last 24 hours (extending to last week it again shows the last on the 9th)

Azure Backup
Azure Backup
An Azure backup service that provides built-in management at scale.
1,353 questions
{count} votes

1 answer

Sort by: Most helpful
  1. SadiqhAhmed-MSFT 48,351 Reputation points Microsoft Employee
    2021-02-12T19:01:25.497+00:00

    Hi anonymous user - Welcome to Microsoft Q&A community forum.
    Apologies for delay in response to your query.

    SQL jobs will not be logged in backup jobs as there would be lot of SQL log backup jobs which will create too many jobs and make it difficult to track. This is by design.

    You may refer to - https://learn.microsoft.com/en-us/azure/backup/backup-azure-monitoring-built-in-monitor#backup-jobs-in-recovery-services-vault

    67522-image.png

    https://learn.microsoft.com/en-us/azure/backup/faq-backup-sql-server#can-i-see-scheduled-backup-jobs-in-the-backup-jobs-menu

    67494-image.png

    You may use log analytics feature for SQL backup reporting
    https://learn.microsoft.com/en-us/azure/backup/backup-azure-monitoring-use-azuremonitor

    ----------------------------------------------------------------------------------------------------------------------

    If the response helped, do "Accept Answer" and up-vote it


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.