Back from Azure

Question

Hello,

I've an Azure Managed Instance, my task is to take databases from the cloud and bringing them back online in an on-premise installation.
I've seen no documentation on this topic.

Anyone could point me to some documentation?

Answer 1

Hi AndreaCaldarone-7697,

Backups from a managed instance can only be restored to another managed instance. They cannot be restored to a SQL Server instance or to Azure SQL Database.
https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/sql-managed-instance-paas-overview#database-migration

As TiborKaraszi said, Using bacpac could be an option.But bacpac will also be challenging with 2 TB data.

some similar cases:
https://social.msdn.microsoft.com/Forums/en-US/c8b769cd-4724-46d7-81a3-ccf43bca9fce/azure-sql-managed-instance-backup-and-restore-on-local-sql-server?forum=ssdsgetstarted

https://social.msdn.microsoft.com/Forums/en-US/cd1d1eac-8581-4b9c-8a3f-eef04a3aff4c/cannot-restore-a-backup-outside-of-azure?forum=ssdsgetstarted

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.