使用OS的工作排程器呼叫.BAT批次檔,並透過在批次檔內執行SQLCMD來備份資料庫。最後,搭配Google Backup and Sync同步到雲端空間。
.BAT批次檔
sqlcmd -S {SQL SERVER NAME} -E -i “{PATH OF .SQL FILE}”
.SQL檔
DECLARE @sql_cmd nvarchar(max) = ‘BACKUP DATABASE {DATABASE NAME} TO DISK = ’’{SAVE PATH}’’ WITH INIT,FORMAT,COMPRESSION’
EXEC sp_executesql @sql_cmd

Leave a comment