Docker SQL SERVER 2019

this is for my preference

Create Volume for data

docker volume create sqlserver_data

Create Volume for logs

docker volume create sqlserver_logs

Create Volume for backups

docker volume create sqlserver_backups

Docker CLI

for wsl via powershell

docker run -e "ACCEPT_EULA=Y" `
  -e "MSSQL_SA_PASSWORD=YourStrongPassword!" `
  -e "MSSQL_PID=Standard" `
  -e "MSSQL_AGENT_ENABLED=true" `
  -e "TZ=Asia/Jakarta" `
  -v sqlserver_data:/var/opt/mssql `
  -v sqlserver_logs:/var/opt/mssql/log `
  -v sqlserver_backups:/var/opt/mssql/backup `
  -p 1433:1433 `
  --name sqlserver_container `
  --user root `
  -d mcr.microsoft.com/mssql/server:2019-latest

for linux

docker run -e "ACCEPT_EULA=Y" \
  -e "MSSQL_SA_PASSWORD=YourStrongPassword!" \
  -e "MSSQL_PID=Standard" \
  -e "MSSQL_AGENT_ENABLED=true" \
  -e "TZ=Asia/Jakarta" \
  -v sqlserver_data:/var/opt/mssql \
  -v sqlserver_logs:/var/opt/mssql/log \
  -v sqlserver_backups:/var/opt/mssql/backup \
  -p 1433:1433 \
  --name sqlserver_container \
  --user root \
  -d mcr.microsoft.com/mssql/server:2019-latest

docker-compose

version: '3.9'

services:
  sqlserver:
    image: mcr.microsoft.com/mssql/server:2019-latest
    container_name: sqlserver_container
    restart: always
    user: root
    environment:
      ACCEPT_EULA: "Y"
      MSSQL_SA_PASSWORD: "YourStrongPassword!"
      MSSQL_PID: "Standard"
      MSSQL_AGENT_ENABLED: "true"
      TZ: "Asia/Jakarta"
    ports:
      - "1433:1433"
    volumes:
      - sqlserver_data:/var/opt/mssql
      - sqlserver_logs:/var/opt/mssql/log
      - sqlserver_backups:/var/opt/mssql/backup

volumes:
  sqlserver_data:
  sqlserver_logs:
  sqlserver_backups:

excalibur1010/docker sqlserver 2019.md

Docker SQL SERVER 2019