Restoring database in azure managed instance from one subscription to another

Question

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

score 0 · Answer 1 · answered Feb 27 '20 at 06:53

0

Restoring the database directly from the portal will not work involving two different subscriptions. It can be done in with Bacpac file as mentioned in this article.

https://www.mssqltips.com/sqlservertip/5189/restore-an-azure-sql-database-from-one-server-to-another-server/

answered Feb 27 '20 at 06:53

threeleggedrabbit

1,722
2
28
60

thank you. i will try to implement this method and will post if it worked for me or not – Priya Sharma Feb 27 '20 at 23:47
For anyone else arriving here looking for a solution for restoring a backup from a Managed Instance to a Managed Instance in different subscription, please note this answer is not targeting that scenario. – Mike Devenney Aug 18 '22 at 14:11

score 0 · Accepted Answer · answered Mar 03 '20 at 05:22

0

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.

answered Mar 03 '20 at 05:22

Shashikant Shakya

114
5

Restoring database in azure managed instance from one subscription to another

2 Answers2