question

mhartman-tigerpaw avatar image
0 Votes"
mhartman-tigerpaw asked AlbertoMorillo edited

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)


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


azure-sql-database
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

AlbertoMorillo avatar image
0 Votes"
AlbertoMorillo answered AlbertoMorillo edited

Please create a bacpac of the database and restore it. Do not try to restore a backup as explained here.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.