在Ubuntu上备份SQL Server数据,常用方法如下:
sudo apt-get update,sudo apt-get install mssql-tools unixodbc-dev。backup_mssql.sh,内容示例:#!/bin/bash
BACKUP_DIR="/var/opt/mssql/data/backup"
DB_SERVER="localhost"
DB_USER="sa"
DB_PASSWORD="your_password"
DB_NAME="YourDatabaseName"
/opt/mssql-tools/bin/sqlcmd -S $DB_SERVER -U $DB_USER -P $DB_PASSWORD -Q "BACKUP DATABASE $DB_NAME TO DISK = '$BACKUP_DIR/$DB_NAME`_full.bak' WITH INIT, SKIP, NAME 'Full Backup'"
3. 赋予脚本执行权限:`chmod +x /path/to/backup_mssql.sh`。
4. 可使用`crontab -e`设置自动备份,如每天凌晨执行:`0 0 * * * /path/to/backup_mssql.sh`。