The backup file is now located inside the container. sudo docker cp wwi.bak sql1:/var/opt/mssql/backup
Use docker cp to copy the backup file into the container in the /var/opt/mssql/backup directory. The following commands navigate to the home/user directory and downloads the backup file as wwi.bak. Next, download the WideWorldImporters-Full.bak file to your host machine. sudo docker exec -it sql1 mkdir /var/opt/mssql/backup The following command creates a /var/opt/mssql/backup directory inside the SQL Server container. Use the following steps to download and copy the Wide World Importers database backup file into your SQL Server container.įirst, use docker exec to create a backup folder. This tutorial uses the Wide World Importers sample database. Replace and with your own password values: sudo docker exec -it sql1 /opt/mssql-tools/bin/sqlcmd \ĭocker exec -it sql1 /opt/mssql-tools/bin/sqlcmd ` Use docker exec to run the sqlcmd utility to change the password through a Transact-SQL statement.
For security purposes, change your SA password:Ĭhoose a strong password to use for the SA user. After you create your SQL Server container, the MSSQL_SA_PASSWORD environment variable you specified is discoverable by running echo $MSSQL_SA_PASSWORD in the container. The SA account is a system administrator on the SQL Server instance that's created during setup. $ sudo docker ps -aĬONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMESĩ41e1bdf8e1d /mssql/server/mssql-server-linux "/bin/sh -c /opt/m." About an hour ago Up About an hour 0.0.0.0:1401->1433/tcp sql1 If the STATUS column for your SQL Server container shows Exited, see the Troubleshooting section of the configuration guide. If the STATUS column shows a status of Up, then SQL Server is running in the container and listening on the port specified in the PORTS column. To view your containers, use the docker ps command. For more information, see Configure SQL Server container images on Docker. This example uses a data volume container within Docker.
0 kommentar(er)
