Skip to content

Instantly share code, notes, and snippets.

@ddpruitt
Forked from dbafromthecold/docker-compose.yaml
Created June 28, 2024 00:42
Show Gist options
  • Save ddpruitt/156c1f6b9786d352ff9d941d05cdb5ef to your computer and use it in GitHub Desktop.
Save ddpruitt/156c1f6b9786d352ff9d941d05cdb5ef to your computer and use it in GitHub Desktop.
Spinning SQL Server 2019 up with docker-compose
version: '3.7'
services:
sqlserver1:
build:
context: .
dockerfile: dockerfile
ports:
- "15789:1433"
env_file:
- sqlserver.env
volumes:
- sqlsystem:/var/opt/mssql/
- sqldata:/var/opt/sqlserver/data
- sqllog:/var/opt/sqlserver/log
- sqlbackup: /var/opt/sqlserver/backup
volumes:
sqlsystem:
sqldata:
sqllog:
sqlbackup:
FROM mcr.microsoft.com/mssql/server:2019-GDR1-ubuntu-16.04
USER root
RUN mkdir /var/opt/sqlserver
RUN mkdir /var/opt/sqlserver/data
RUN mkdir /var/opt/sqlserver/log
RUN mkdir /var/opt/sqlserver/backup
RUN chown -R mssql /var/opt/sqlserver
USER mssql
CMD /opt/mssql/bin/sqlservr
SA_PASSWORD=Testing1122
ACCEPT_EULA=Y
MSSQL_DATA_DIR=/var/opt/sqlserver/data
MSSQL_LOG_DIR=/var/opt/sqlserver/log
MSSQL_BACKUP_DIR=/var/opt/sqlserver/backup
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment