I try to restore a .bak file Azure Sql Edge container with Azure Data Studio. I have Apple M1 chipset. I am using docker for mssql:
mcr.microsoft.com/azure-sql-edge latest 5dba915af82f 8 weeks ago 1.83GB
I need to install Mssql and restore a database with .bak file. But I get below error:
Restore FilelistOnly from disk = N'/var/opt/mssql/backup/test.bak'
Restore Database test From disk = N'/var/opt/mssql/backup/test.bak' WITH REPLACE, RECOVERY, MOVE 'test_data' TO '/var/opt/mssql/data/test.mdf', MOVE 'test_Log' TO '/var/opt/mssql/data/test.ldf'
Msg 12824, Level 16, State 1, Line 2 The sp_configure value
‘contained database authentication’ must be set to 1 in order to
restore a contained database. You may need to use RECONFIGURE to set
the value_in_use.
I try to
sp_configure 'contained database authentication', 1;
GO
RECONFIGURE;
GO
I am getting:
Msg 15392, Level 16, State 1, Procedure sp_configure, Line 166 The
specified option ‘contained database authentication’ is not supported
by this edition of SQL Server and cannot be changed using
sp_configure.
How to restore my backup on azure sql edge?
2
Answers
You’re running Azure SQL Edge, which is a special edition intended for IoT scenarios.
Per the docs
Backup and Restore – Azure SQL Edge
And Contained Databases are not supported in Azure SQL Edge.
So either start with a backup of a non-contained database, or use one of the "regular" SQL Server Editions on Docker.
Regular SQL docker editions for M1 Apple Silicon is still not supported. Azure SQL Edge not usefull for this activity. So can not import bak or bacpac files to local sql via M1 macs!