Blog Post

Azure Database Support Blog
1 MIN READ

Lesson Learned #146: Restoring a backup from Azure SQL Managed Instance to OnPremises

Jose_Manuel_Jurado's avatar
Jose_Manuel_Jurado
Icon for Microsoft rankMicrosoft
Nov 23, 2020
We saw several service request where our customer want to restore a backup taken in Azure SQL Managed Instance to SQL Server OnPremise and they are getting the following error: Msg 3169, Level 16, St...
Updated Nov 23, 2020
Version 2.0
Arnold_Lieberman's avatar
Arnold_Lieberman
Copper Contributor
Jun 01, 2022

As a follow-up to my comment above, I have now successfully tested restoring a BYOK TDE-encrypted native backup that was created by SQL MI into SQL Server 2022.

The limitation of not being able to spin up/down SQL MI on demand still stands but SQL Server has become a viable route to bursty processing of data.