• suedunham2 (11/24/2014)


    Thank you for that prompt reply - it looks like there is no way of reducing the size of the first Monday tran log dump unless I change the database from full to simple recovery mode for the duration of the maint plan. Is that something you would recommend?

    Absolutely NOT!

    That's throwing away your point in time recovery (the entire reason for being in full recovery) and renders you vulnerable to data loss if there's a problem.

    As for your maintenance, stop using the maintenance plan for indexes and stats and start using Ola's solution instead http://ola.hallengren.com/

    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