docker sqlserver 数据库备份脚本

在容器里执行备份命令,生成备份脚本

拷贝备份脚本到本地存储

#/bin/bash

# get date
now=$(date +%Y-%m-%d)

# get container id, only one container, let's do it
CONTAINER_ID=`docker container ls | sed -n '2p' | cut -f 1 -d ' '`


# backup 数据库, 不需要 -it 这两个options
docker exec  $CONTAINER_ID /opt/mssql-tools/bin/sqlcmd \
   -S localhost -U sa -P 'Yukon900' \
   -Q "BACKUP DATABASE [Demodata] TO DISK = N'/var/opt/mssql/backup/demodata.bak' WITH NOFORMAT, NOINIT, NAME = 'WideWorldImporters-full', SKIP, NOREWIND, NOUNLOAD, STATS = 10"

# 重新命名文件
docker exec  $CONTAINER_ID mv /var/opt/mssql/backup/demodata.bak /var/opt/mssql/backup/$now"_demodata.bak"
# copy backup file from container to local host
docker cp $CONTAINER_ID:/var/opt/mssql/backup/$now"_demodata.bak" .

# remove backup file in the container
docker exec $CONTAINER_ID  rm /var/opt/mssql/backup/$now"_demodata.bak"

参考链接

1. restore-backup-in-sql-server-container
2. Shell 命令执行结果赋值给变量
3. error-the-input-device-is-not-a-tty