469,602 Members | 1,838 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,602 developers. It's quick & easy.

Transaction File Backups Not Deleting after specified timeframe

We have a fairly straightforward maint plan on one of our servers (MSSQL 2K)...it backs up several DB's to a folder on another server (the one with the tape drive) so they can be archived to tape. The .BAK files have a "Keep for" time of 5 days, and that seems to be working Fine Business...the .TRN files have a "Keep for" time of 7 days, but they seem to be not deleting after that timeframe...or at all...when I noticed (after spilling over into a 2nd backup tape), there were transaction files back to when this server was brought online last May...

Any thoughts...the transaction tab and the backup tab look pretty much identical save for the number of days for retention...Of course it's better that we're deleting too little rather than too much, but still, "'Tis a puzzlement!"

Thanks--
Dan in Tacoma
Jan 23 '08 #1
0 1056

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

10 posts views Thread by TZoner | last post: by
3 posts views Thread by Bucfan1 | last post: by
2 posts views Thread by francois1 | last post: by
4 posts views Thread by yashgt | last post: by
reply views Thread by Edwin.Madari | last post: by
reply views Thread by guiromero | last post: by
reply views Thread by devrayhaan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.