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

  • October 11, 2013 at 4:34 am

    #1657846

    clucasi (10/11/2013)

    The main reason for backing up sequentially is because we are taking a further backup on a tape drive (TSM), if the backups are date based it backs each file, so we get a new on the tape each day...

    That's exactly the way you want it to happen. Spend a little money on buying tapes and come up with a proper tape rotation. I don't know when it will happen, of course, but overwriting tapes every night will cost you someday.

    --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)