RestAPI Query SQL Server BackupJobs

Question

I want to monitor all my backup jobs with size information and error messages so i use the endpoint "backupJobs" from the recovery services.

https://learn.microsoft.com/en-us/rest/api/backup/backupjobs/list

I get all my VM backups and also backups from my MARS Agents. My problem is, i am not getting any output for my SQL server backups or transaction log backups.

How can I get information about the SQL backups that include at least server name/database, backup amount, return code and error messages?

[Note: As we migrate from MSDN, this question has been posted by an Azure Cloud Engineer as a frequently asked question] Source: BackupJobs FAQ

Answer 1

REST API doesn't provide information of scheduled SQL backup jobs https://learn.microsoft.com/en-us/azure/backup/backup-azure-monitoring-built-in-monitor#backup-jobs-in-recovery-services-vault. If you want to get information on scheduled backup jobs, you will have to use Log Analytics. https://learn.microsoft.com/en-us/azure/backup/backup-azure-diagnostic-events

Source: https://social.msdn.microsoft.com/Forums/en-US/a1628441-6a2a-4d7a-806a-2a7b59e49468/restapi-query-sql-server-backupjobs?forum=windowsazureonlinebackup