June 18, 2009 at 10:01 am
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!!
June 18, 2009 at 10:50 am
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