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.
45 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,329 questions
0 comments No comments
{count} votes

Accepted answer
  1. Oury Ba-MSFT 15,276 Reputation points Microsoft Employee
    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

    0 comments No comments

0 additional answers

Sort by: Most helpful