Microsoft.Sql/servers/databases/backupLongTermRetentionPolicies

Question

not valid anymore

Answer 1

Hi Muhammed Meethal •,

Welcome to Microsoft Q&A forum and thanks for using Azure Services.

As I understand, you are trying to add long term retention policy on the SQL DB using azure policy with Microsoft.Sql/servers/databases/backupLongTermRetentionPolicies and could not find it.

Please refer to the below LTR limitations:

• When restoring from an LTR backup, the read scale property is disabled. To enable, read scale on the restored database, update the database after it has been created.
• You need to specify the target service level objective, when restoring from an LTR backup, which was created when the database was in an elastic pool.
• LTR in the Hyperscale service tier is in limited public preview.

Could you please let us know the configuration details of the Azure SQL Database?

Note:

LTR can be enabled for Hyperscale databases created or migrated from other service tiers after June 2022. LTR support for all other Hyperscale databases will be added over the next several weeks. If you attempt to enable LTR for a Hyperscale database where it is not yet supported, you will receive the following error: "Long Term Retention is not supported: Long-term retention on Hyperscale is currently in limited preview and cannot be enabled as yet for your database. To enable long-term retention please reach out to Microsoft support." Please create a support ticket to resolve this, or wait until LTR support is enabled for your database.

Reference:https://learn.microsoft.com/en-us/azure/azure-sql/database/long-term-backup-retention-configure?view=azuresql-db&tabs=portal

Let us know your database details and if it meets above limitations.

Thank you