• Then the failure was from one of the later tasks. You need to log the output of the maintenance plan to tell exactly where.

    btw, why on earth are you both rebuilding the indexes and reorganising them. Bit of a waste of time there.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass