Tuesday, October 27, 2009

SQL Maintenance Plans

For each instance I like to make a single Maintenance plan with several subplans:

Subplans:
  1. System Databases Tasks
    1. Reorganize Index
    2. Update Statistics
    3. Back Up Database
    4. Check Database Integrity
    5. Notify Operator of Failure
    6. Notify Operator of Success
  2. User Databases Tasks
    1. Reorganize Index
    2. Update Statistics
    3. Back Up Database
    4. Check Database Integrity
    5. Notify Operator of Failure
    6. Notify Operator of Success
  3. Daily Transaction Logs Tasks
    1. Back Up Database (Transaction log type)
    2. Notify Operator of Success
    3. Notify Operator of Failure
  4. Hourly Transaction Logs Tasks
    1. Back Up Database (Transaction log type)
    2. Notify Operator of Success
    3. Notify Operator of Failure
  5. Cleanup Logs Tasks
    1. Back Up Database (Transaction log type)
    2. Notify Operator of Success
    3. Notify Operator of Failure

Maintenance Cleanup
Notify Operator

No comments: