I am trying to restore a backup from an Azure Managed Instance to an SQL Server running on an Azure VM. When running the Backup Script, I get this error Message:
Meldung 3169, Ebene 16, Status 1, Zeile 2
The database was backed up on a server running version 15.00.2000. That version is incompatible with this server, which is running version 15.00.4073.
Either restore the database on a server that supports the backup, or use a backup that is compatible with this server.
Firstly, when running the Script
SELECT @@VERSION
the managed instance seems to run on version 12.0.2000.8 and secondly, the new SQL Server is running a newer version than the source DB from the error print, which means it shouldn't be a problem, right?
What am I missing?
Thanks in advance
Justus
The output from @@VERSION from the Managed Instance is misleading.
Because a Managed Instance is an evergreen deployment (it is ALWAYS the latest version) this means that it is always a newer version than any version of SQL Server you will get on a VM.
You will need to consider other methods such as BACPACs or replication to get your DB copy on the VM