Restore SQL Server database to Linux Docker

Question

I need to restore a large SQL Server database on a Linux Docker instance (https://hub.docker.com/r/microsoft/mssql-server-linux/)

I'm moving my .bak file to the docker and executing this command in mssql shell:

RESTORE DATABASE gIMM_Brag FROM DISK = '/var/opt/mssql/backup/BackupFull8H_gIMM.bak' WITH MOVE '[gIMM].Data' T'/var/opt/mssql/data/gIMM.mdf', MOVE '[gIMM].Log' TO '/var/opt/mssql/data/gIMM.ldf', MOVE 'TraceabilityData' TO '/var/opt/mssql/data/gIMM.TraceData.mdf', MOVE 'TraceabilityIndexes' TO '/var/opt/mssql/data/gIMM.TraceIndex.mdf', MOVE 'KpiData' TO '/var/opt/mssql/data/gIMM.KpiData.mdf', MOVE 'KpiIndexes' TO '/var/opt/mssql/data/gIMM.KpiIndex.mdf'

I'm mapping correctly every file that need to and I definitely have enough space on the docker instance but I'm getting this error:

Error: The backup or restore was aborted.

The same error occurs with a windows version of this docker actually... And as it's not supposed to be a Express version, the database size shouldn't be the issue here.

If anyone has more information about what is causing this error !

Thanks,

Where exactly you are trying to restore data, to the Image itself or in container? — Hrishi
– Hrishi, Commented Mar 2, 2017 at 8:04

Vinicius Krauspenhar · Accepted Answer · 2017-10-13 20:35:26Z

7

@TOUDIdel You have to use the actual file system paths on linux rather than the virtual paths that are shown in the error.

RESTORE DATABASE Northwind FROM DISK='/var/opt/mssql/Northwind.bak' WITH MOVE 'Northwind' TO '/var/opt/mssql/data/NORTHWND.MDF', MOVE 'Northwind_log' TO '/var/opt/mssql/data/NORTHWND_log.ldf'

http://www.raditha.com/blog/archives/restoring-a-database-on-ms-sql-server-for-linux-docker/

answered Oct 13, 2017 at 20:35

Vinicius Krauspenhar

711 silver badge2 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

TabsNotSpaces · Accepted Answer · 2017-03-07 03:08:47Z

5

You didn't mention it, but the thing that tricked me up was that I wasn't copying the BAK file to my Docker instance.

In Terminal with docker and your mssql container running...

1) get container ID:
$docker inspect -f '{{.Id}}' <container_name>

2) copy BAK file to docker instance:
docker exec -i <container_id> bash -c 'cat > /var/opt/mssql/backup.bak' < '/source/path/backup.bak'

3) log into mssql:
mssql -u sa -p 'myPassword'

3) restore db: (you can replace this with your restore script, though this was sufficient for me)
RESTORE DATABASE [MyDatabase] FROM DISK = N'/var/opt/mssql/backup.bak' WITH FILE = 1, NOUNLOAD, REPLACE, STATS = 5

answered Mar 7, 2017 at 3:08

TabsNotSpaces

1,3771 gold badge11 silver badges25 bronze badges

4 Comments

TOUDIdel Over a year ago

During restore I receive: SQL Error [5133] [S0001]: Directory lookup for the file "c:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\DATA\database.mdf" failed with the operating system error 2(The system cannot find the file specified.). com.microsoft.sqlserver.jdbc.SQLServerException: Directory lookup for the file "c:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\DATA\database.mdf" failed with the operating system error 2(The system cannot find the file specified.).

bluesummers Over a year ago

Did you solve this? I'm getting the same issue @TOUDIdel

TabsNotSpaces Over a year ago

@TOUDIdel sorry, I was not able to replicate your error

TOUDIdel Over a year ago

@bluesummers: Unfortunately not

Uwe Keim · Accepted Answer · 2017-07-24 08:43:37Z

4

When I had this problem, it's because the restore command was taking long enough for mssql to time out (with a totally unhelpful error message). Specifying a long timeout when connecting allowed the restore to complete. eg

mssql -s localhost -p "<sa_password>" -t 36000000 -T 36000000

edited Jul 24, 2017 at 8:43

Uwe Keim

40.9k61 gold badges193 silver badges308 bronze badges

answered Mar 2, 2017 at 6:37

Kevin Dente

25.8k7 gold badges45 silver badges47 bronze badges

1 Comment

Keith C Over a year ago

Kevin, Your post here just saved me hours of checking random things.

Simas Joneliunas · Accepted Answer · 2019-11-24 08:55:07Z

I am not sure it is worth mentioning, but neither of the answers alone worked when moving a .bak made in Windows server to the docker running in Linux version.

(Note that I am using the code from the two previous answers and thus any credit should go to the below-mentioned authors)

TabsNotSpaces' solution was good until step 3 where the restore crashed with path mismatch (C:/path_to_mssql_server could not be found).

Vinicius Krauspenhar's answer was then necessary to remap the MDF and LOG files to fully complete the backup.

Thus the solution that worked for me when importing a windows-server-made .bak file into the Linux docker instance was:

In Terminal with docker and your SQL Server container running...

1) get container ID: $docker inspect -f '{{.Id}}' <container_name>

2) copy BAK file to docker instance: docker exec -i <container_id> bash -c 'cat > /var/opt/mssql/backup.bak' < '/source/path/backup.bak'

3) log into mssql or in any DB software and RESTORE DATABASE Northwind FROM DISK='/var/opt/mssql/Northwind.bak' WITH MOVE 'Northwind' TO '/var/opt/mssql/data/NORTHWND.MDF', MOVE 'Northwind_log' TO '/var/opt/mssql/data/NORTHWND_log.ldf'

Collectives™ on Stack Overflow

Restore SQL Server database to Linux Docker

4 Answers 4

Comments

4 Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

4 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related