Docker Community Forums

Share and learn in the Docker community.

Database Restore Error on mcr.microsoft.com/mssql/server: 2017-latest

Hi All,

I am restoring adventureworks db on 2017 linux docker using following command. Towards the end
of the restore i am getting error as below.

TIA

–TSQL Restore Command
RESTORE DATABASE AdventureWorks2017
FROM disk = ‘/var/opt/mssql/data/AdventureWorks2017.bak’
WITH
MOVE ‘AdventureWorks2017’ to ‘sqldatafiles/AdventureWorks2017.mdf’
, MOVE ‘AdventureWorks2017_log’ to ‘/sqldatafiles/AdventureWorks2017_Log.ldf’
, RECOVERY

–Error
Msg 3013, Level 16, State 1, Line 19
RESTORE DATABASE is terminating abnormally.
Msg 5159, Level 24, State 5, Line 19
Operating system error (null) on file “sqldatafiles/AdventureWorks2017_Log.ldf” during MakePreviousWritesDurable.