azureazure-sql-managed-instanceazure-managed-database

Restoring database in azure managed instance from one subscription to another


I have my production database in one subscription and dev/test database in other subscription. how can i restore database from production to test?


Solution

  • Restoring to different subscription is not possible. Use copy_only backup to URL option and restore it to another sqlmi instance. If service managed TDE is blocker then try disabling it or use customer managed BYOK TDE settings.