I'm trying to restore a SQL Server 2016 database into a SQL Server 2017 docker instance (
microsoft/mssql-server-linux:latest). The process seems to be:
- Create docker container:
docker run -e ‘ACCEPT_EULA=Y’ -e ‘SA_PASSWORD=<strong password>’ -p 1433:1433 --name 'sql1' microsoft/mssql-server-linux
- Create backup directory:
docker exec -it sql1 mkdir /var/opt/mssql/backup
- Copy backup to directory:
docker cp Foobar.bak sql1:/var/opt/mssql/backup
- Login to mssql server:
mssql -o 1433 -u sa -p
- Get list of backed up files:
restore filelistonly from disk='/var/opt/mssql/backup/Foobar.bak'<- each row returned will result in a
movecommand in the next step
- Restore database:
restore database Foobar from disk='/var/opt/mssql/backup/Foobar.bak' with stats=10, replace, move 'Foobar' to '/var/opt/mssql/data/Foobar.mdf', move 'Foobar_log' to '/var/opt/mssql/data/Foobar.ldf'
The last step is failing with the output:
Error: The backup or restore was aborted.
I tried to find an error log, and found
/var/opt/mssql/log/errorlog. AFAICT, nothing gets output in this file from my aborted restore operation.
How can I determine what is happening? Are there logs available that I can use to get more info?