Automatic backup immutability for Azure SQL DB and Azure SQL MI | Data Exposed
Anna Hoffman walks through automatic backup immutability for Azure SQL Database and Azure SQL Managed Instance in a Q&A-style Data Exposed episode.
Overview
The session explains what backup immutability means in Azure SQL, why it matters for protecting backups (for example, against tampering and ransomware scenarios), and how the feature works at a high level.
Key topics covered:
- Why immutability matters for database backup protection
- What “backup immutability” means in practice
- How to turn on automatic backup immutability
- How many days of immutable backups can be kept (retention)
- Support across Azure SQL Database vs Azure SQL Managed Instance, and what’s on the roadmap
- How to check whether backups are immutable
- What WORM (Write Once, Read Many) means in this context
- What happens to immutable backups if a database is deleted