Installing sample database

(skip if you already installed container) use powershell or powershell tab of cmder to execute following command if you did not install sql server container

docker run `
--name FooSqlServer `
-e sa_password=FooSqlServer101 `
-e 'ACCEPT_EULA=Y' `
-p 1433:1433 `
-d microsoft/mssql-server-windows-developer:2017-latest

Copying from host to container

stop container: docker stop FooSqlServer

docker cp C:\Users\fooUser\Downloads\AdventureWorks2017.bak FooSqlServer:C:\AdventureWorksDW2017.bak

star container: docker start FooSqlServer

Restoring backup using SSMS

Databases > Right click > Restore Database

Restoring backup using SSMS - image 1

Restoring backup using SSMS - image 2

Restoring backup using SSMS - image 3

Restoring backup using SSMS - image 4