How do I see Azure SQL Database automatic backups report on Backup Center

Question

Is there a way that I can configure Azure SQL Database backups to show on Azure Backup Center?

I need to do some reporting on the backups but it looks like there is no way to pull them in backup center.

Answer 1

@Gomolemo Greetings!

Azure Backup Center is a centralized portal for managing and monitoring backups across various Azure resources, but as of my last update, it does not natively support Azure SQL Database backups in its dashboard. Azure SQL Database has its own set of tools and interfaces for backup management and reporting.

However, you can integrate Azure SQL Database backup information into your reporting framework through other means:

Azure SQL Database Backup Reporting

Azure SQL Database provides its own mechanisms for backup and restore operations:

• Azure Portal: You can view backup details and recovery options directly in the Azure Portal under the Azure SQL Database resource. This includes backup retention periods and recovery points.
• T-SQL: You can use T-SQL queries to get information about your backups. For instance: SELECT database_name, backup_type, backup_start_date, backup_finish_date, recovery_model, backup_size FROM sys.backup_set ORDER BY backup_finish_date DESC;
  • Azure Resource Graph: For querying and aggregating backup information across multiple resources, you can use Azure Resource Graph. Here’s an example query:
  resources | where type == "microsoft.sql/servers/databases" | project id, name, location, properties

Azure Monitor and Log Analytics

You can use Azure Monitor and Log Analytics to collect and analyze backup-related metrics and logs:

• Configure Diagnostic Settings: Set up diagnostic settings on your Azure SQL Database to send logs and metrics to Log Analytics.
• Query Logs: Use Kusto Query Language (KQL) to query and analyze backup data from Log Analytics: AzureDiagnostics | where ResourceType == "SQLDatabase" and Category == "AuditLogs" | summarize Count = count() by bin(TimeGenerated, 1d), OperationName
• PowerShell and Azure CLI You can use PowerShell or Azure CLI to script and automate the retrieval of backup information:
  • PowerShell Example:
  • $resourceGroupName = "yourResourceGroup" $serverName = "yourServerName" $databaseName = "yourDatabaseName" Get-AzSqlDatabase -ResourceGroupName $resourceGroupName -ServerName $serverName -DatabaseName $databaseName
• Azure CLI Example: az sql db show --resource-group yourResourceGroup --server yourServerName --name yourDatabaseName

Custom Reporting Solutions

If you need to include Azure SQL Database backups in a custom reporting solution:

• Extract Data: Use the methods mentioned above (Portal, T-SQL, Azure Monitor, PowerShell, CLI) to extract backup information.
• Integrate Data: Create custom reports by integrating this extracted data into your reporting framework or dashboard.

Hope this help. Please write back to us if you have any questions.

---

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