Azure SQL Database
An Azure relational database service.
5,672 questions
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
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 57.99999999999999%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMH%3C/text%3E%3C/svg%3E)
Mike Hartman
26
Reputation points
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)
ADDITIONAL INFORMATION:
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!
Mike