SQL Backup with email alert

在左邊Toolbox -> Maintenance Plan Tasks尋找Back Up Database Task, 然後Drop it到右邊窗格

Double Click Back Up Database Task, 以下備份設定, 請根據需要修改和設定

Toolbox -> Maintenance Plan Tasks -> Shrink Database Task

Toolbox -> Maintenance Plan Tasks -> Rebuild Index Task

Toolbox -> Maintenance Plan Tasks -> Maintenance Cleanup Task

Toolbox -> Maintenance Plan Tasks -> Notify Operator Task

Toolbox -> Maintenance Plan Tasks -> Notify Operator Task

最後設定Schedule

記得要Save

發佈留言

*