Create a SQL-on-Linux container, and restore the AdventureWorks2016 DB

QuickSQLContainer_wAW2016.ps1

$BakURL = "https://github.com/Microsoft/sql-server-samples/releases/download/adventureworks/AdventureWorks2016.bak"
$BakFile = "$($Home)\Downloads\AdventureWorks2016.bak"
Invoke-WebRequest -Uri $BakURL -OutFile $BakFile

mkdir C:\SQLData\Docker\SQLDev02
#dir  C:\SQLData\Docker\SQLDev02 | OGV -PassThru | Remove-Item

Copy-Item -Path "$($Home)\Downloads\AdventureWorks2016.bak" -Destination C:\SQLData\Docker\SQLDev02

<# Create a Container with a volume mounted from the host #>
docker run -d -p 10002:1433 -v C:\SQLData\Docker\SQLDev02:/sqlserver --env ACCEPT_EULA=Y --env SA_PASSWORD=Test1234 --name testcontainer02 microsoft/mssql-server-linux:latest
<# Make sure to say Yes and add your username & password so Docker can connect to the volume-location. #>

<# via Invoke-SqlCmd to Host-Mount #>
New-StoredCredential -Target "SqlDocker" -UserName "sa" -Password "Test1234" -Persist LocalMachine

$cred = Get-StoredCredential -Target "SqlDocker"

Invoke-Sqlcmd -ServerInstance 'localhost,10002' -Credential $cred -Query "SELECT name from sys.databases"

#Requires -Modules SqlServer 
Invoke-Sqlcmd -ServerInstance 'localhost,10002' -Credential $cred -Query "
RESTORE DATABASE [AdventureWorks2016] FROM  DISK = N'/sqlserver/AdventureWorks2016.bak' WITH  FILE = 1,  
MOVE N'AdventureWorks2016_Data' TO N'/sqlserver/AdventureWorks2016_Data.mdf',  
MOVE N'AdventureWorks2016_Log' TO N'/sqlserver/AdventureWorks2016_Log.ldf',  
NOUNLOAD,  STATS = 5"

Invoke-Sqlcmd -ServerInstance 'localhost,10002' -Credential $cred -Query "SELECT name from sys.databases"