Azure SQL Managed Instance: on-demand native backups and TDE
Memo and references on on-demand COPY_ONLY backups to Blob Storage and customer-managed TDE.
On Azure SQL Managed Instance, automatic backups are handled by the service, but you can also take native on-demand backups to Azure Blob Storage (BACKUP DATABASE ... TO URL, as COPY_ONLY). This memo gathers the useful references.
Key points
- Manual on-demand backups are
COPY_ONLYand do not interfere with the automatic backup chain. - If the database is encrypted with service-managed TDE, a
COPY_ONLYbackup is not possible: it is recommended to use your own key (customer-managed TDE, "bring your own key" through Azure Key Vault).