Blog Post

Azure SQL Blog
4 MIN READ

Restoring a SQL Managed Instance database backup to SQL Server 2022 (Private Preview)

Mladen_Andzic's avatar
Mladen_Andzic
Icon for Microsoft rankMicrosoft
Jun 27, 2022
Note: The capability is now generally available. Check the announcement for the up-to date information.   Restoring a backup file is the easiest way to copy a SQL Server database to another insta...
Updated Nov 23, 2022
Version 12.0
azure sql managed instance
sql server
chris dickey's avatar
chris dickey
Copper Contributor
Jul 05, 2022

Do I have it correct that the main limiting factor at this time of restoring a database to SQL Server 2022 from SQL Managed Instance is changes need to Managed Instance so that its version does not change?
I have been looking for documentation on restoring to SQL Server 2022 from SQL MI. I just found this post which is very recent. Before I found this post, I was thinking the restore feature might work in the public preview of SQL Server 2022 with a current SQL MI database. Apparently not.