What are the challenges you face when working across database platforms? Take the survey

WITH ERASEFILES not counting correctly??

fhanlonfhanlon Posts: 17 Bronze 2
edited July 24, 2006 5:49PM in SQL Backup Previous Versions
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


  • Options
    peteypetey Posts: 2,358 New member
    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.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    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...
Sign In or Register to comment.