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?