# Azure SQL Database Managed Instance

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

## Whitepaper

- Commvault Azure SQL Protection

×

Loading...