locked
30 minute Transaction Log back up RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    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.


    AG


    Thursday, February 23, 2017 10:43 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    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