You can use the Commvault software to back up and restore databases in an Azure SQL Managed Instance.
Backups
The software utilizes the Microsoft $BACKUP DATABASE mechanism to protect Azure SQL Managed Instance databases. This mechanism only supports taking a COPY_ONLY full backup.
By default, COPY_ONLY backups of system-managed transparent data encrypted (TDE) databases are not supported by Azure; however, you can protect databases with customer-managed TDE keys. For more information, go to the Move a transparent data encryption-protected database section on the Transparent data encryption for SQL Managed Instance page on the Microsoft documentation website.
Alternatively, use the DacFX (Data-tier Application Framework) toolset-based, logical backups for Azure SQL Managed Instance (MI) databases encrypted using service-managed keys. For more information, see Configure Backups for TDE-Encrypted Databases Using Service-Managed Keys.
Backup Granularity
- Database and Instance Level
Data You Can Back Up
- Managed instances
Backups You Can Perform
- Full backups
When You Can Perform Backups
-
On a schedule: The backup plan that you assign manages scheduled backups
-
On demand: You can perform on-demand backups at any time
Restores
Backup Granularity
- Database Level
Backups You Can Use for Restores
-
The most recent backup: For example, restore the most recent backup to its original location
-
A backup from a specific date: For example, restore data to a point in time before it became unusable
-
Backups from a date range: For example, restore data that was accidentally deleted
Destinations You Can Restore To
-
A different managed instance
-
A disk