linux下備份sqlserver

1、先建立backup檔案夾

cd /var/opt/mssql/
mkdir ./backup
           

2、修改backup檔案夾的檔案歸屬和分組

chown mssql:mssql ./backup
           

3、執行備份語句，利用sqlcmd指令執行

BACKUP DATABASE yourDB 
TO DISK = '/var/opt/mssql/backup/yourDB2018-2-6.bak'   
WITH FORMAT; 
GO