Kinda Newbie question about backups and expired backup sets

  • This may be a stupid question .. but .. What exactly is an "Expired BackUp Set" By definition it means the expiredate is when the backup set will be expired and overwritten .. but I am not 100% sure what that means for me .. We take daily backups and tran logs backups that are written to individual files that are date stamped. We store 7 days on disk, and back them up to tape.. where they are saved for 30 days. If the backup set is older then say 7 days, which is what it is set to in the maint plan .. what does that do to my backups on tape.. can I not recover from them if I have problems? I think I just need some clarity .. Thanks!!

  • That option really has nothing to do with file based backups. It is a legacy option for backups that went directly to tape where you would have to mark the backup on the tape as expired so it could be overwritten.

    I don't set that option or use it at all for any of my SQL Server backups.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply