last sync: 2025-May-14 18:52:07 UTC

SQL DB Backup Retention

Community Policy definition

Source Repository Community-Policy GitHub
JSON Community-Policy GitHub
Deploy policy c31683cf-8bf5-420c-b26b-68f33c0ea9b5 (1.0.0) to Azure
Display name SQL DB Backup Retention
Id c31683cf-8bf5-420c-b26b-68f33c0ea9b5
Version 1.0.0
Details on versioning
Category SQL
Microsoft Learn
Description This policy modifies any Azure SQL Database to ensure a minimum number of retention days for short-term backups.
Mode Indexed
Type Custom Community
Effect Default
DeployIfNotExists
Allowed
DeployIfNotExists, AuditIfNotExists, Disabled
RBAC role(s)
Role Name Role Id
SQL DB Contributor 9b7fa17d-e63e-47b0-bb0a-15c516ac86ec
SQL Security Manager 056cd41c-7e88-42e1-933e-88ba6a50c9c3
Rule aliases THEN-ExistenceCondition (1)
Alias Namespace ResourceType Path PathIsDefault DefaultPath Modifiable
Microsoft.Sql/servers/databases/backupShortTermRetentionPolicies/retentionDays Microsoft.Sql servers/databases/backupShortTermRetentionPolicies properties.retentionDays True True
Rule resource types IF (1)
Microsoft.Sql/servers/databases
THEN-Deployment (1)
Microsoft.Sql/servers/databases/backupShortTermRetentionPolicies
JSON
EPAC
Deploy policy c31683cf-8bf5-420c-b26b-68f33c0ea9b5 (1.0.0) to Azure