How can we help you today? How can we help you today?

WITH ERASEFILES not counting correctly??

Maybe I'm going buggy but when I run a backup uing either WITH ERASEFILES = 2 or WITH ERASEFILES=48h, then backups older than 24 hours or 1 day are being deleted. Can you duplicate this on your end? I notice this on my transaction log files. I want to keep 2 days of backup on disk, so I use WITH ERASEFILES=2, but everytime thebackup runs all transation files older than 1 day get removed. :shock:

btw I'm using 4.5 of SQL Backup
fhanlon
0

Comments

2 comments

Sort by
  • petey
    Are you trx log backups taking longer to complete? E.g.

    Day 1, backup starts at 2 a.m, completes at 2:05 a.m.

    Day 2, backup completes at 2:06 a.m.

    Day 3, backup completes at 2:07 a.m, in which case day 1's backups are more than 2 days old.
    petey
    0
  • Betelgeuse
    Interesting, I'm having the opposite problem. I want only one copy of backups on disk but with ERASEFILES = 1, the previous night's backups are NOT deleted. I could use ERASEFILES = 23h, but I have a lot of Agent jobs to edit...
    Betelgeuse
    0

Add comment

Please sign in to leave a comment.