Restore MS SQL 2K db into docker

[netmac]

Thanks for the MSDE docker. Great tool.

Actually I am trying to restore a MSSQL2000 .bak file to no avail. I am able to connect to the docker from the host using osql and execute regular queries.

But a RESTORE query does not work neither when I point to the bak in the host, nor when I point to the bak in the guest (after copying the file)

I have always error like :

Msg 3201, Level 16, State 2, Server cf3d671f80fb, Line 1 Cannot open backup device 'c:\mydb.bak'. Device error or device off-line. See the SQL Server error log for more details. Msg 3013, Level 16, State 1, Server cf3d671f80fb, Line 1 RESTORE DATABASE is terminating abnormally.

On the other hand when I connect into the MSDE docker, and try to execute OSQL.ex with wine 👍 Ex : /usr/bin/wine /root/.wine/drive_c/Program\ Files/Microsoft\ SQL\ Server/80/Tools/Binn/OSQL.EXE

I have this error :

Error: Locale or Codepage not properly installed on this machine

Any idea?

Thanks

[rsmoorthy]

I had done this long back. The only thing I was successful, was able to access it via the TCP port.

I am sorry. I have forgotten almost all of it. Unable to help you on this.