1Panel MSSQL (TXCOS) 备份恢复

安装MSSQL for Docker

查看 挂载卷

/opt/1panel/apps/mssql/mssql/data -> /var/opt/mssql/data

安装COSCLI

https://cloud.tencent.com/document/product/436/63144#linux

根据配置配置

然后把备份复制到本地
注意bak目录是自己创建的

coscli cp COS://xxxxx/db/xxxx_backup_2026_08_12_000016_7517072.full.bak /opt/1panel/apps/mssql/mssql/data/bak/

恢复数据

若有占用要切换到 master 或断开数据库 xxxx 的所有链接。

RESTORE DATABASE xxxx
FROM DISK='/var/opt/mssql/data/bak/xxxx_backup_2026_08_12_000016_7517072.full.bak'
WITH
MOVE 'xxxxdb_Data'
TO '/var/opt/mssql/data/xxxx.mdf',
MOVE 'xxxxdb_Log'
TO '/var/opt/mssql/data/xxxx_log.ldf',
REPLACE,
RECOVERY;
GO

验证兼容

SELECT name, state_desc, compatibility_level
FROM sys.databases
WHERE name='xxxx';