Azure SQL Managed Instance TDE

I have a database with TDE enabled in a SQL Managed Instance. I need to backup and restore this database to an On-Prem SQL Server 2022. How can I restore the TDE encrypted backup without disabling TDE on that database in SQL-MI?

I need this to transfer the data to one or more On-Prem test systems.

So far I only found instructions that either deal with moving an On-Prem DB with TDE enabled to Azure SQL-MI or the way back by dropping TDE on the database that should be backed up and restored in SQL-MI.

Can anyone give me some hint how to manage this problem?

Thanks in advance

Johannes

Read more here: Source link