Skip to main content
All CollectionsCapacity Management Suite®
SQL Maintenance Plans - Capacity Management Suite®
SQL Maintenance Plans - Capacity Management Suite®

This article will provide information pertaining SQL maintenance plans, along with a description for each one.

William Pelino avatar
Written by William Pelino
Updated over 6 months ago

Info


Capacity Management Suite® Maintenance Plans

  • The script run on initial install creates the “XT Maintenance Plan” Plan for the XT, XTIguana and XTArchive databases. If the training databases are present at time of installation the plan will includes those databases as well).

  • Job name - XT Maintenance Plan.FullBackup

    • Creates a full backup of the XT, XTIguana and XTArchive databases.

    • Is scheduled for every Sunday at 2:00AM

    • Backups are retained for 14 days and located in the default backup directory.

  • Job name - XT Maintenance Plan.Integrity

    • Checks database integrity including indexes

    • Is scheduled for every Sunday at 3:00AM

  • Job name - XT Maintenance Plan.Optimization

    • Rebuild all indexes

    • Changes free space to default setting

    • Is scheduled for every Sunday at 4:00AM

  • Job name - XT Maintenance Plan.TranBackup

    • Creates a transaction log backup of the XT and XTIguana transaction logs.

    • Is scheduled for every Monday, Tuesday, Wednesday, Thursday, Friday and Saturday at 2:00AM

    • Backups are retained for 14 days and located in the default backup directory

Did this answer your question?