Can't use Azure Sql Edge backup due to it being version 964.

Victor Irzak 20 Reputation points
2024-01-22T13:02:28.3466667+00:00

Is there any way to restore an Azure SQL Edge database anywhere other than on Azure SQL Edge? I have the latest CUs on SQL Server Express and LocalDB, but it still wouldn't take an Azure SQL Edge backup. Here is the message:

Microsoft.Data.SqlClient.SqlError: The database was backed up on a server running database version 964. That version is incompatible with this server, which supports version 957. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server. (Microsoft.SqlServer.SmoExtended)

Please advise

Azure SQL Edge
Azure SQL Edge

An Azure service that provides a small-footprint, edge-optimized data engine with built-in artificial intelligence. Previously known as Azure SQL Database Edge.

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

0 comments
Answer accepted by question author
Oury Ba-MSFT 21,156 Reputation points Microsoft Employee Moderator
2024-01-22T21:20:40.81+00:00

@Victor Irzak
Thank you for reaching out. Azure SQL Edge can only be restored from a local disk, a network location, or an Azure Blob storage account. Please do check the following doc for more details on how to back up an azure SQL DB edge from local file or blob storage account. Back up and restore databases in Azure SQL EdgeUser's image Regards, Oury

Was this answer helpful?

0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.