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