Skip to content

Instantly share code, notes, and snippets.

@dmtrek14
Created July 15, 2022 16:37
Show Gist options
  • Save dmtrek14/ca62de007b97967939ccb2cc4f8ae456 to your computer and use it in GitHub Desktop.
Save dmtrek14/ca62de007b97967939ccb2cc4f8ae456 to your computer and use it in GitHub Desktop.
Commands for spinning up SQL Server in a Docker container with persistent storage to a volume and creation of a backup folder.
sudo docker pull mcr.microsoft.com/mssql/server:2022-latest
sudo docker run -e "ACCEPT_EULA=Y" -e 'MSSQL_SA_PASSWORD=<my-secure-password>' --name 'my-db-name' -p 1433:1433 -v my-db-name-data:/var/opt/mssql -d mcr.microsoft.com/mssql/server:2022-latest
sudo docker exec -it my-db-name mkdir /var/opt/mssql/backup
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment