last sync: 2022-Jun-28 16:32:57 UTC

Azure Policy definition

SQL Database should avoid using GRS backup redundancy

Name SQL Database should avoid using GRS backup redundancy
Azure Portal
Id b219b9cf-f672-4f96-9ab0-f5a3ac5e1c13
Version 2.0.0
details on versioning
Category SQL
Microsoft docs
Description Databases should avoid using the default geo-redundant storage for backups, if data residency rules require data to stay within a specific region. Note: Azure Policy is not enforced when creating a database using T-SQL. If not explicitly specified, database with geo-redundant backup storage is created via T-SQL.
Mode Indexed
Type BuiltIn
Preview FALSE
Deprecated FALSE
Effect Default: Deny
Allowed: (Deny, Disabled)
Used RBAC Role none
Rule Aliases IF (3)
Alias Namespace ResourceType DefaultPath Modifiable
Microsoft.Sql/servers/databases/edition Microsoft.Sql servers/databases sku.tier false
Microsoft.Sql/servers/databases/requestedBackupStorageRedundancy Microsoft.Sql servers/databases properties.requestedBackupStorageRedundancy false
Microsoft.Sql/servers/databases/storageAccountType Microsoft.Sql servers/databases properties.requestedBackupStorageRedundancy false
Rule ResourceTypes IF (1)
Date/Time (UTC ymd) (i) Change type Change detail
2021-04-27 15:38:15 change Major (1.0.1 > 2.0.0)
2021-02-10 14:43:58 change Patch (1.0.0 > 1.0.1) *changes on text case sensitivity are not tracked
2020-09-09 11:24:03 add b219b9cf-f672-4f96-9ab0-f5a3ac5e1c13
Used in Initiatives
Initiative DisplayName Initiative Id Initiative Category State Type
[Preview]: RMIT Malaysia 97a6d4f1-3bed-4cf4-ac5b-0e444c0408d6 Regulatory Compliance Preview BuiltIn
JSON Changes