Update SQL Database Retention PoliciesΒΆ

Update any SQL Database short term retentions to at least 7 days

policies:
   - name: update-short-term-backup-retention-policy
     resource: azure.sqldatabase
     filters:
     - type: short-term-backup-retention
        op: lt
        retention-period-days: 7
     actions:
     - type: update-short-term-backup-retention
        retention-period-days: 7

Enforce a 1 month maximum retention for weekly backups on all SQL Databases

policies:
   - name: update-long-term-backup-retention-policy
     resource: azure.sqldatabase
     filters:
     - type: long-term-backup-retention
        backup-type: weekly
        op: gt
        retention-period: 1
        retention-period-units: months
     actions:
     - type: update-long-term-backup-retention
        backup-type: weekly
        retention-period: 1
        retention-period-units: months