30 minute Transaction Log back up RRS feed

  • Question

  • I take transaction log back up ever 30 minutes - but every day at about 05:30 the back up takes 01:30 and increases each day. Can anyone help.


    Thursday, February 23, 2017 10:43 AM


  • Hello,

    Nothing uncommon and I don't see any issue with it. I guess that a Job runs at that time, e.g. defrag Indexes, archieving old data or some other data maintenances; that can increase log backup size.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Marked as answer by ANGanley MCSD Thursday, February 23, 2017 1:08 PM
    Thursday, February 23, 2017 11:37 AM