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

Comments

No comments yet. Why don’t you start the discussion?

發佈留言

發佈留言必須填寫的電子郵件地址不會公開。 必填欄位標示為 *

*