I tried to restore a database by Azure SQL Edge docker on Mac M1, I got "Database size would exceed license limitation" error.

woodymoo 256 Reputation points
2022-12-09T18:04:22.293+00:00

Is there full version of Azure SQL edge docker for ARM? How can I restore the database on ARM (mac) system?
I got the following error when I tried to restore a sql server database by Azure SQL edge container on MAC os M1 max. If it could be restored, the database size is 2.3T, and bak db file is 950G.

Microsoft.Data.SqlClient.SqlError: CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 1048576 MB per database. (Microsoft.SqlServer.SmoExtended)

This Azure SQL edge docker is running well on my apple MBP M1 max with other smaller databases.

Thanks,

Azure SQL Database
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
0 comments
Accepted answer
  1. GeethaThatipatri-MSFT 27,642 Reputation points Microsoft Employee
    2022-12-14T14:27:15.22+00:00

    Hi,@woodymoo Thanks for posting your question in the Microsoft Q&A forum.
    Thanks to @Alberto Morillo for sharing your input.
    There is a 1 TB limit on database size in Azure SQL Edge. This was not previously included in the documentation, and we are working to get that updated.

    Are you using SQL Edge on M1 for an Edge-specific project, or because that’s the only version of SQL Server that currently runs on M1 CPUs? please confirm.

    Regards
    Geetha

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Alberto Morillo 32,891 Reputation points MVP
    2022-12-09T19:04:14.637+00:00

    Azure SQL Edge containers are based on Ubuntu 18.04, and as such are only supported to run on Docker hosts running either Ubuntu 18.04 LTS (recommended) or Ubuntu 20.04 LTS.

    Make sure you make a Docker installation compatible with Mac here. Install Azure SQL Edge using YAML and Docker Compose V2. You can also use the following command: 

    docker run -e 'ACCEPT_EULA=1' -e 'MSSQL_SA_PASSWORD=bigStrongPwd' -p 1433:1433 --name sqledge -d mcr.microsoft.com/azure-sql-edge

    Databases created in Azure SQL Edge cannot be restored on an instance of Microsoft SQL Server

    0 comments