In this post I'll show how we can restore a database when starting up a docker container for the first time. First in the Dockerfile, we will need to make sure we are moving the backup into the container as a part of the build process. In my Dockerfile, I'll create a backup folder and… Continue reading Restore a SQL Server database in Docker
Category: docker
Using SQLCMD to check if SQL is running
In my previous post we use a simple sleep command to wait out the sql start up and prevent our sql commands from executing too early. I wanted to see if I could write a better check for this and not have to hope my guess at a sleep time is correct. I was able… Continue reading Using SQLCMD to check if SQL is running
Running mssql on docker
Here is a quick walk through to setup a simple MSSQL instance on docker and initialize the instance with a data. First we will setup a few scripts to startup sql, create a database and initialize it with data. entrypoint.sh #start SQL Server, start the script to create/setup the DB /init.sh & /opt/mssql/bin/sqlservr init.sh --… Continue reading Running mssql on docker
