【Mac】在docker中还原数据库

最新推荐文章于 2024-03-12 15:15:05 发布

村口小张

最新推荐文章于 2024-03-12 15:15:05 发布

阅读量599

点赞数 1

本文链接：https://blog.csdn.net/weixin_40590984/article/details/104672137

版权

Mac 同时被 2 个专栏收录

2 篇文章 0 订阅

订阅专栏

Docker

2 篇文章 0 订阅

订阅专栏

准备

1 Docker连接SQL Server

还原数据库

1 创建镜像sql1的文件目录并拷贝文件

*backup_name 替换为需还原的备份文件路径

sudo docker exec -it sql1 mkdir /var/opt/mssql/backup

sudo docker cp backup_name.bak sql1:/var/opt/mssql/backup

2进入容器,执行命令

*container_name 替换为容器名

sudo docker exec -it container_name /bin/bash

使用RESTORE FILELISTONLY命令列出备份数据文件的逻辑名

/opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P 'dev@123,' -Q 'RESTORE FILELISTONLY FROM DISK = "/var/opt/mssql/backup/backup_name.bak"' | tr -s ' ' | cut -d ' ' -f 1-2

使用RESTORE DATABASE命令还原数据库

*database_name替换为要还原的数据库名称

/opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P 'dev@123,' -Q 'RESTORE DATABASE database_name FROM DISK = "/var/opt/mssql/backup/backup_name.bak" WITH MOVE "database_name" TO "/var/opt/mssql/data/database_name.mdf" , MOVE "database_name_log" TO "/var/opt/mssql/data/database_name_log.ldf"'