Home Forums SQL Server 2005 SQL Server Newbies Failed Simple Maintenance Plan only when Full Backups do not run RE: Failed Simple Maintenance Plan only when Full Backups do not run

  • Thanks for the replies!

    Yes the logs are explicitly set to 40 GB today. They were set to 20 GB in the past.

    No replication or mirroring.

    I'm looking at the job and its type is listed as an SSIS package. Does this make sense?

    Exection tasks:

    Database Integrity - Include Indexes

    Rebuild Indexes - Default free space per page - Sort results in tempdb

    Update Statistics - Column Stats Only - Full Scan

    Maintenance Cleanup - Delete files: maintenance plan text reports - Age: Older than 2 weeks

    History Cleanup - Delete files: Backup and Restore, SQL Server Agent job History, Maintenance Plan History - Age: Older than 2 weeks