Restore TDS enabled Managed instance database to on premise sql server

Question

I have a Azure Managed instance database with TDE enabled (customer managed keys) , i need to take copy_only .bak backup for this MI database to azure blob storage using SAS URL(I achieved this by creating certificate and running Tsql query) . Now my use case is i need to move this backup file to on premise and restore it , is this even a viable option? I dont want to use dacpac/backpac export it has to be .bak restore process

• Should the on premise sql server needs to be TDE enabled?
• Do i need to export the azure managed instance database Customer managed key to on prem?

Answer 1

@SethuRam Thank you for providing more context.

If you cannot use a bacpac and must use a .bak file to restore the database, I would recommend disabling TDE and then taking a backup from MI.
You can then configure TDE on your on-premises SQL Server separately.

----------

If an answer is helpful, please "Accept answer" or "Up-Vote" which might help other community members reading this thread.
And if you have further questions or issues, please let us know.