Azure Managed Database Backup Reporting

Kevin I 1 Reputation point
2020-09-17T14:14:47.903+00:00

We've setup a Managed database in a SQL Managed Instance and we need to report on the backup status. I appreciate that backups are a mixture of full, incremental and transaction logs, but we need some form of reporting to indicate when a backups are run.

I've looked into using Log Analytics but can't see how to include a Managed Database backup.

Any advice would be gratefully received.

Thanks

Kevin

Azure SQL Database
Azure Monitor
Azure Monitor
An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
1,829 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Mike Ubezzi 2,771 Reputation points
    2020-09-18T18:59:13.19+00:00

    Hi @Kevin I - Please review the Azure SQL Analytics (Preview) feature that is part of Azure Monitor. This functionality gives you the best option for establishing alerts and building reports/views into your Managed Instance database. There are specific support options pertaining to Azure SQL Database and Azure SQL Managed Instance.

    By creating a notification based upon using a combination of: Resource by type, Insights, and/or Errors, you can build a reporting mechanism on the backup tasks.

    25854-screenshot-267.png

    No comments