Docker Community Forums

Share and learn in the Docker community.

Database Restore Error on 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.


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

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.