You can use the Commvault software to back up and restore databases in an Azure SQL Managed Instance.
Backups
Commvault uses the Microsoft BACKUP DATABASE command to protect Azure SQL Managed Instance databases by performing COPY_ONLY full backups.
Backup support depends on the database's transparent data encryption (TDE) configuration:
-
TDE disabled: Supported by default.
-
Customer-managed TDE keys: Supported by default.
-
Service-managed TDE keys: Not supported by the default BACKUP TO URL mechanism. To protect these databases, see Configure Backups for TDE-Encrypted Databases Using Service-Managed Keys.
For information about TDE-protected database migration requirements, see Transparent data encryption for SQL Managed Instance in the Microsoft documentation.
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