Backup TDE enabled Database in Azure SQL Managed Instance

Question

Hi Guys,

I wanted to backup my TDE enabled database in Azure SQL Managed Instance .

Is it possible to do copy_only backup of my TDE database to blob storage container directly like below.

I wanted to migrate this TDE enabled DB from my on-prem to managed instance with the same key that i created in on-prem instance.

please throw some insights.

BACKUP DATABASE tpcc2501 
TO URL = 'https://myacc.blob.core.windows.net/testcontainer/tpcc2501.bak' 
WITH COPY_ONLY 

Thanks

Answer 1

Good day udhayan,

The following document covers the whole topic:
Azure SQL Transparent Data Encryption with customer-managed keys in Azure Key Vault: Bring Your Own Key support

---

Ronen Ariely  [Personal Site]    [Blog]    [Facebook]    [Linkedin]

Answer 2

Thanks Ronen.