last sync: 2022-May-23 16:32:10 UTC

Azure Policy definition

Long-term geo-redundant backup should be enabled for Azure SQL Databases

Name Long-term geo-redundant backup should be enabled for Azure SQL Databases
Azure Portal
Id d38fc420-0735-4ef3-ac11-c806f651a570
Version 2.0.0
details on versioning
Category SQL
Microsoft docs
Description This policy audits any Azure SQL Database with long-term geo-redundant backup not enabled.
Mode Indexed
Type BuiltIn
Preview FALSE
Deprecated FALSE
Effect Default: AuditIfNotExists
Allowed: (AuditIfNotExists, Disabled)
Used RBAC Role none
Rule Aliases THEN-ExistenceCondition (3)
Alias Namespace ResourceType DefaultPath Modifiable
Microsoft.Sql/servers/databases/backupLongTermRetentionPolicies/monthlyRetention Microsoft.Sql servers/databases/backupLongTermRetentionPolicies properties.monthlyRetention false
Microsoft.Sql/servers/databases/backupLongTermRetentionPolicies/weeklyRetention Microsoft.Sql servers/databases/backupLongTermRetentionPolicies properties.weeklyRetention false
Microsoft.Sql/servers/databases/backupLongTermRetentionPolicies/yearlyRetention Microsoft.Sql servers/databases/backupLongTermRetentionPolicies properties.yearlyRetention false
Rule ResourceTypes IF (1)
Microsoft.Sql/servers/databases
History
Date/Time (UTC ymd) (i) Change type Change detail
2020-12-11 15:42:52 change Major (1.0.0 > 2.0.0)
2019-10-29 23:04:36 add d38fc420-0735-4ef3-ac11-c806f651a570
Used in Initiatives
Initiative DisplayName Initiative Id Initiative Category State Type
[Deprecated]: Azure Security Benchmark v1 42a694ed-f65e-42b2-aa9e-8052e9740a92 Regulatory Compliance Deprecated BuiltIn
[Deprecated]: Azure Security Benchmark v2 bb522ac1-bc39-4957-b194-429bcd3bcb0b Regulatory Compliance Deprecated BuiltIn
[Deprecated]: DoD Impact Level 4 8d792a84-723c-4d92-a3c3-e4ed16a2d133 Regulatory Compliance Deprecated BuiltIn
[Preview]: RMIT Malaysia 97a6d4f1-3bed-4cf4-ac5b-0e444c0408d6 Regulatory Compliance Preview BuiltIn
[Preview]: SWIFT CSCF v2021 abf84fac-f817-a70c-14b5-47eec767458a Regulatory Compliance Preview BuiltIn
CMMC Level 3 b5629c75-5c77-4422-87b9-2509e680f8de Regulatory Compliance GA BuiltIn
FedRAMP High d5264498-16f4-418a-b659-fa7ef418175f Regulatory Compliance GA BuiltIn
FedRAMP Moderate e95f5a9f-57ad-4d03-bb0b-b1d16db93693 Regulatory Compliance GA BuiltIn
HITRUST/HIPAA a169a624-5599-4385-a696-c8d643089fab Regulatory Compliance GA BuiltIn
NIST SP 800-53 Rev. 4 cf25b9c1-bd23-4eb6-bd2c-f4f3ac644a5f Regulatory Compliance GA BuiltIn
NIST SP 800-53 Rev. 5 179d1daa-458f-4e47-8086-2a68d0d6c38f Regulatory Compliance GA BuiltIn
JSON Changes

JSON