Bak restore from local http server corrupted file

[Dennis-Do]

Hello,

I try to restore a bak file hosted on a local http server while I am creating a new container with the create command. For testing purpose I downloaded the bak file from https://aka.ms/AdventureWorksLT.bak.

When I copy the file to the container with 'docker cp' command I can successful restore ist. So the file is ok.

When I try to restore the file with the following command the file seems corrupted:

sqlcmd create mssql --name express --accept-eula --using http://localhost:3000/files/WideWorldImporters-Full.bak

I then get the following error message:

The file is in the right container folder, the size of the file is the same as before but even if I try to restore it a manually after the creation of the container it seems as there is no database backup in the file.

As http server I used a nodejs express instance:

`const express = require('express')
const app = express()
const port = 3000

app.use(express.static('public'))

app.listen(port, () => {
console.log(Example app listening on port ${port})
})`

Please can somebody explain me why it is not working before I get crazy?

[shueybubbles]

Per the linked PR, Copilot says that the "localhost" specified in the argument is relative to the container, not to the host running sqlcmd.
If that's the case you'll need to configure your docker networking to use a hostname that can be resolved within the container.