sqlcmd -S localhost -U SA -P '密碼' -Q "BACKUP DATABASE [數據庫名] TO DISK='/var/opt/mssql/data/[數據庫名]_full.bak' WITH INIT, SKIP, NAME='Full Backup'"
。sqlcmd -S localhost -U SA -P '密碼' -Q "BACKUP DATABASE [數據庫名] TO DISK='/var/opt/mssql/data/[數據庫名]_diff.bak' WITH DIFFERENTIAL, INIT, SKIP, NAME='Differential Backup'"
。sqlcmd -S localhost -U SA -P '密碼' -Q "BACKUP LOG [數據庫名] TO DISK='/var/opt/mssql/data/[數據庫名]_log.bak' WITH INIT, SKIP"
。mssql_backup.sh
),用crontab -e
設置定時任務,如每天凌晨執行。sqlcmd -S localhost -U SA -P '密碼' -Q "RESTORE DATABASE [數據庫名] FROM DISK='/var/opt/mssql/data/[數據庫名]_full.bak' WITH NORECOVERY"
。sqlcmd -S localhost -U SA -P '密碼' -Q "RESTORE DATABASE [數據庫名] FROM DISK='/var/opt/mssql/data/[數據庫名]_diff.bak' WITH NORECOVERY"
。sqlcmd -S localhost -U SA -P '密碼' -Q "RESTORE LOG [數據庫名] FROM DISK='/var/opt/mssql/data/[數據庫名]_log.bak' WITH RECOVERY"
。