Question 84149 in Docker Question posted in
The official documentation can be found here.

Bak File Backup Restore Docker Azure SQL Edge in M1 Apple

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?

Tags:

2

Answers


  1. 0

    You’re running Azure SQL Edge, which is a special edition intended for IoT scenarios.

    Per the docs

    Additionally, a database created on Microsoft SQL Server or Azure SQL
    can be restored on Azure SQL Edge, provided the database does not
    contain any of the features not supported by Azure SQL Edge.

    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.

    Login or Signup to reply.
  2. 0

    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!

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search