Terraform-provider-azurerm: Feature Request: Backup Policy type "SQL Server in Azure VM"

[joeyjesky]

Community Note

• Please vote on this issue by adding a 👍 reaction to the original issue to help the community and maintainers prioritize this request
• Please do not leave "+1" or "me too" comments, they generate extra noise for issue followers and do not help prioritize the request
• If you are interested in working on this issue or have submitted a pull request, please leave a comment

Description

The ability to create a backup policy for Policy Type = 'SQL Server in Azure VM'

New or Affected Resource(s)

Cannot create backup policy for SQL Server in Azure VM.

• azurerm_recovery_services_protection_policy_vm

Potential Terraform Configuration

       {
  "condition": "[parameters('isNewPolicy')]",
  "type": "Microsoft.RecoveryServices/vaults/backupPolicies",
  "apiVersion": "2018-01-10",
  "name": "[concat(parameters('vaultName'), '/', parameters('policyName'))]",
  "dependsOn": [
    "[resourceId('Microsoft.RecoveryServices/vaults/', parameters('vaultName'))]"
  ],
  "properties": {
    "backupManagementType": "[variables('backupManagementType')]",
    "workloadType": "[parameters('workloadType')]",
    "settings": {
      "timeZone": "UTC",
      "issqlcompression": false,
      "isCompression": false
    },
    "subProtectionPolicy": [
      {
        "policyType": "Full",
        "schedulePolicy": {
            "schedulePolicyType": "SimpleSchedulePolicy",
            "scheduleRunFrequency": "Daily",
            "scheduleRunTimes": [
                "2019-03-24T16:00:00Z"
            ],
            "scheduleWeeklyFrequency": 0
        },
        "retentionPolicy": {
            "retentionPolicyType": "LongTermRetentionPolicy",
            "dailySchedule": {
                "retentionTimes": [
                    "2019-03-24T16:00:00Z"
                ],
                "retentionDuration": {
                    "count": 30,
                    "durationType": "Days"
                }
            }
        }
      },
      {
          "policyType": "Log",
          "schedulePolicy": {
              "schedulePolicyType": "LogSchedulePolicy",
              "scheduleFrequencyInMins": 60
          },
          "retentionPolicy": {
              "retentionPolicyType": "SimpleRetentionPolicy",
              "retentionDuration": {
                  "count": 30,
                  "durationType": "Days"
              }
          }
      }
    ]
  }
},

References

https://github.com/Azure/azure-quickstart-templates/tree/master/101-recovery-services-vm-workload-backup

• #0000

[Rod-Sychev]

It's been awhile, any updates on this request?

[Sam123ben]

Hello team, any update on this as I still dont see that in the terraform yet.

[nicksin-leroux]

Was there any movement on this ?

[liomaz]

Very interested by this feature. Any news?

[ChorltonPaul]

Extremely interested in this. Moving from Storage Account backups to RSV's has many advantages and at the moment I'm having to use azurerm_template_deployment to achieve it in terraform which is less than ideal. Any news?

[starskythehutch]

Extremely interested in this. Moving from Storage Account backups to RSV's has many advantages and at the moment I'm having to use azurerm_template_deployment to achieve it in terraform which is less than ideal. Any news?

@ChorltonPaul I'm looking to do exactly the same. Are you able to share your current terraform code which achieves it?