Author : MD TAREQ HASSAN

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