last sync: 2020-Oct-01 14:15:17 UTC

Azure Policy

SQL Managed Instances should avoid using GRS backup redundancy

Policy DisplayName SQL Managed Instances should avoid using GRS backup redundancy
Policy Id a9934fd7-29f2-4e6d-ab3d-607ea38e9079
Policy Category SQL
Policy Description Managed Instances should avoid using GRS storage for backups if data residency rules require data to stay within a specific region.
Policy Mode Indexed
Policy Type BuiltIn
Policy in Preview FALSE
Policy Deprecated FALSE
Policy Effect Default: Deny
Allowed: (Deny,Disabled)
Roles used none
Policy Changes
Date/Time (UTC ymd) (i) Change Change detail
2020-09-09 11:24:03 add: Policy a9934fd7-29f2-4e6d-ab3d-607ea38e9079
Used in Policy Initiative(s) none
Policy Rule
{
  "properties": {
    "displayName": "SQL Managed Instances should avoid using GRS backup redundancy",
    "policyType": "BuiltIn",
    "mode": "Indexed",
    "description": "Managed Instances should avoid using GRS storage for backups if data residency rules require data to stay within a specific region.",
    "metadata": {
      "version": "1.0.0",
      "category": "SQL"
    },
    "parameters": {
      "effect": {
        "type": "String",
        "metadata": {
          "displayName": "Effect",
          "description": "Enable or disable the execution of the policy"
        },
        "allowedValues": [
          "Deny",
          "Disabled"
        ],
        "defaultValue": "Deny"
      }
    },
    "policyRule": {
      "if": {
        "allOf": [
          {
            "field": "type",
            "equals": "Microsoft.Sql/managedInstances"
          },
          {
            "not": {
              "anyOf": [
                {
                  "field": "Microsoft.Sql/managedInstances/storageAccountType",
                  "equals": "LRS"
                },
                {
                  "field": "Microsoft.Sql/managedInstances/storageAccountType",
                  "equals": "ZRS"
                }
              ]
            }
          }
        ]
      },
      "then": {
      "effect": "[parameters('effect')]"
      }
    }
  },
  "id": "/providers/Microsoft.Authorization/policyDefinitions/a9934fd7-29f2-4e6d-ab3d-607ea38e9079",
  "type": "Microsoft.Authorization/policyDefinitions",
  "name": "a9934fd7-29f2-4e6d-ab3d-607ea38e9079"
}