AzPolicyAdvertizer

last sync: 2023-Jun-19 17:45:01 UTC

Community Policy definition

SQL DB Backup Retention

Name SQL DB Backup Retention
Community-Policy GitHub
Id sql_deploy-sql-database-shortterm-backup-retention-policy
Version 1.0.0
details on versioning
Category SQL
Microsoft docs
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
AuditIfNotExists
Allowed
AuditIfNotExists, DeployIfNotExists, Disabled
Used RBAC Role
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 DefaultPath Modifiable
Microsoft.Sql/servers/databases/backupShortTermRetentionPolicies/retentionDays Microsoft.Sql servers/databases/backupShortTermRetentionPolicies properties.retentionDays false
Rule ResourceTypes IF (1)
Microsoft.Sql/servers/databases
THEN-Deployment (1)
Microsoft.Sql/servers/databases/backupShortTermRetentionPolicies
JSON