Home Forums SQL Server 2008 SQL Server Newbies Transaction log backup file is too big RE: Transaction log backup file is too big

  • February 12, 2013 at 7:56 am

    #1587030

    Beatrix Kiddo (2/12/2013)

    GilaMonster (2/12/2013)

    Beatrix Kiddo (2/12/2013)

    I know how to produce a backup file with the date in the name, but where does that leave me when I need it to be overwritten each night?

    In a very bad situation if you overwrite the old backup with a backup that proves to be unrestorable...

    But surely not if the previous day's backup has been backed up offsite before the file is overwritten each day?

    How long does it take to fetch the offsite backup, and how long will you have to restore a DB in the case of a disaster?

    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