docker恢复sqlserver备份数据库

首先安装sqlserver映射本地磁盘

docker run -it -e SA_PASSWORD=Active#123 -e SQLSERVER_DATABASE=test -e SQLSERVER_USER=test -e SQLSERVER_PASSWORD=test -p 1433:1433  --name mysqlserver -v ~/data/sqlserver:/opt/backup exoplatform/sqlserver

使用docker exec 进入容器

docker exec -it mysqlserver /bin/bash

执行sqlcmd

/opt/mssql-tools/bin/sqlcmd  -U SA -P 'Active#123'

执行备份文件

RESTORE database mydb FROM disk='/opt/backup/mydb.bak'
WITH MOVE 'mydb' TO '/opt/data/mydb.ndf', 
MOVE 'mydb_log' TO '/opt/data/mydb_log.ldf'