Share via

Get backup schedule and retention (short and long term) for SQL Servers using Azure Resource Graph Explorer

Arun Mittal 0 Reputation points
2023-06-17T16:58:50.2733333+00:00

I am trying to get the backup schedule and retention for SQL Servers using Azure Resource Graph Explorer. I am unable to find any such information.

The current query that I have is

resources
| where type == 'microsoft.sql/servers'

I am trying to get the short term and long term backup information for SQL Servers and databases but it doesn't seem to exist in the resources table. I am not sure where this information is stored. I couldn't find anything in recoveryservicesresources table related to PaaS instance of SQL Server backups.

Any ideas?

PS: I am trying to do this using KQL. I know it is possible using PowerShell using 'Get-AzSqlDatabaseBackupShortTermRetentionPolicy' and 'Get-AzSqlDatabaseBackupLongTermRetentionPolicy'.

Azure SQL Database

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Oury Ba-MSFT 20,716 Reputation points Microsoft Employee
    2024-09-24T00:07:06.3066667+00:00
    0 comments

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.