https://pulumi.com logo
Title
p

powerful-football-81694

04/07/2021, 10:49 AM
Hi everyone! I’m trying to figure out how to configure long term backup retention policies for an Azure SQL Database using the native provider. In ARM terms (according to the portal) it looks like this:
{
            "type": "Microsoft.Sql/servers/databases/backupLongTermRetentionPolicies",
            "apiVersion": "2020-08-01-preview",
            "name": "[concat(parameters('servers_***_dev_sql_name'), '/licensing-dev-db/default')]",
            "dependsOn": [
                "[resourceId('Microsoft.Sql/servers/databases', parameters('servers_***_dev_sql_name'), 'licensing-dev-db')]",
                "[resourceId('Microsoft.Sql/servers', parameters('servers_***_dev_sql_name'))]"
            ],
            "properties": {
                "weeklyRetention": "PT0S",
                "monthlyRetention": "PT0S",
                "yearlyRetention": "PT0S",
                "weekOfYear": 0
            }
        },
I cannot find any resource types that look even remotely similar in any of the namespaces I’ve checked. Neither in the default, nor in
Latest
nor in
V20200801Preview
which seems to be what the portal uses for these. Can anyone point me in the right direction?
t

tall-librarian-49374

04/07/2021, 11:03 AM
It looks like it’s one of the resources that don’t have full CRUD API so we need to do some manual work to map them to our resource model. Could you open an issue and I’ll add this resource in the next release?
p

powerful-football-81694

04/07/2021, 11:09 AM
Yeah I’m happy to.
Until then, it’s fine to create this manually, and it won’t be negated by a
pulumi up
somehow right?
t

tall-librarian-49374

04/07/2021, 11:10 AM
Yes, I believe this should be safe
p

powerful-football-81694

04/07/2021, 11:34 AM