Immutable backups

Azure SQL LTR backups can now be time-immutable for new restore points — but only after the policy is enabled and locked

NEWSUpdated 07/09/20267 min read

Time-based backup immutability is now available for Azure SQL Database LTR backups: once the policy is enabled and locked, protected backups can’t be deleted or modified until the retention window ends. But it only covers backups created after the lock.

Backup & Resilience

Immutable long-term retention is available for Azure SQL Database LTR, but not for Azure SQL Managed Instance LTR in the same way

NEWSUpdated 10/09/20266 min read6 views

Microsoft’s new time-based immutability for Azure SQL Database long-term retention backups makes them non-modifiable and non-erasable during the immutability period. That strengthens the trustworthiness of recovery points, but teams still need recovery discipline and tested restores—especially for Managed Instance.

> Search or run a command

#Immutable backups

Azure SQL LTR backups can now be time-immutable for new restore points — but only after the policy is enabled and locked

Immutable long-term retention is available for Azure SQL Database LTR, but not for Azure SQL Managed Instance LTR in the same way