Please create a bacpac of the database and restore it. Do not try to restore a backup as explained here.
Restore a database from a Managed instance to a local SQL Server
We are getting the following message when trying to restore a database from a SQL Managed instance to an on-premise sql server:
TITLE: Microsoft SQL Server Management Studio
Restore of database '330547' failed. (Microsoft.SqlServer.Management.RelationalEngineTasks)
System.Data.SqlClient.SqlError: The database was backed up on a server running version 15.00.2148. That version is incompatible with this server, which is running version 15.00.4138. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server. (Microsoft.SqlServer.SmoExtended)
What is the proper way to restore a SQL Azure managed instance database to an on-premise SQL server?
Thanks in advance!
Sign in to comment
0 additional answers
Sort by: Most helpful