thombolin/mssql_attach

By thombolin

Updated over 6 years ago

SQL2017 Image attach database on RUN

Image

30

SQL2017 Image attaches database stored in c:\temp on host, c:\sqlserver in container. Currently hard coded database name of dockertest using dockertest.mdf and dockertest_log.ldf stored in c:\temp on host

#escape=` FROM microsoft/mssql-server-windows-developer:latest

#create directory within SQL container for database files RUN powershell mkdir C:\SQLServer

#copy the database files from host to container #COPY SQLFiles\DockerTest.mdf C:\SQLServer #COPY SQLFiles\DockerTest_log.ldf C:\SQLServer

#SET ENV VARIABLES FOR EULA, DATA_PATH (USED IN OTHER SCRIPTS) AND SA_PASSWORD (SET VIA start script in MSSQL image) ENV ACCEPT_EULA="Y" SA_PASSWORD="SQLServer2017" attach_dbs='[{"dbName":"dockertest","dbFiles":["C:\SQLServer\DockerTest.mdf","C:\SQLServer\DockerTest_log.ldf"]}]'

#docker run -d -p1433:1433 -v c:\temp:c:\sqlserver --name sql01 thombolin/mssql_attach

Docker Pull Command

docker pull thombolin/mssql_attach