Restore TDS enabled Managed instance database to on premise sql server

SethuRam 66 Reputation points

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?
Azure Database Migration service
{count} votes

1 answer

Sort by: Most helpful
  1. KalyanChanumolu-MSFT 8,316 Reputation points

    @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.

    0 comments No comments