Azure-docs: Arm Template

[johnstaveley]

Please can you provide resources to configure backups using an arm template? (Or at least a link to the correct resource)

---

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

• ID: a40f786f-e6c9-15f5-d80a-b4d4eb7a39f5
• Version Independent ID: 12620513-5d3c-b7a2-32c9-294117ff3d57
• Content: Manage Azure SQL Database long-term backup retention
• Content Source: articles/sql-database/sql-database-long-term-backup-retention-configure.md
• Service: sql-database
• GitHub Login: @anosov1960
• Microsoft Alias: sashan

[CHEEKATLAPRADEEP-MSFT]

@johnstaveley Thank you for your interest in Azure products and services. We are investigating and will update you shortly.

[CarlRabeler]

@MashaMSFT please work with @anosov1960 to respond to this git issue

[MashaMSFT]

Hi @johnstaveley , thank you for contacting Microsoft! I did some research and unfortunately was unable to find an Azure Quickstart Template that configures backups. Can you please share your request with the engineering team via UserVoice so they know this is a need customers have? Since there is little the content team can do to assist you with this further, I will proceed with closing out this Git Issue. However, please let me know if the SQL content team can be of further assistance to you. Thanks! #please-close

[johnstaveley]

@MashaMSFT Hi, I found a solution. Something like this works:

 {
  "type": "Microsoft.Sql/servers/databases/backupLongTermRetentionPolicies",
  "name": "[concat(variables('webDatabaseName'), '/Default')]",
  "tags": { "displayName": "Database Backup" },
  "apiVersion": "2017-03-01-preview",
  "location": "UK West",
  "scale": null,
  "properties": {
    "weeklyRetention": "P4W"
  },
  "dependsOn": [
    "[resourceId('Microsoft.Sql/servers', variables('sqlServerName'))]",
    "[resourceId('Microsoft.Sql/servers/databases', variables('sqlserverName'), variables('webDatabase'))]",
  ]
},