Home Forums SQL Server 2005 Backups Sequential number sql hourly tl backups RE: Sequential number sql hourly tl backups

  • October 10, 2013 at 4:21 pm

    #1657748

    clucasi (10/4/2013)

    Hi All,

    I wonder if anybody could help with this problem.

    We are performing a full backup at 12:01 and then we want TL backup every hour until the next full backup, the next day the TL backups want to be overwritten with the new TL backup, is it possible to have a sequential count in the file name (from 1 -23).

    Hope i am not confusing the issue:-D

    Since each file has a date/time associated with it, I believe that sequentially numbering backups is an overcomplication that should probably be avoided. In other words, keep it simple. 😉

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)