Problem erasing old files

antounb

I'm using SQL backup 5 Lite. I noticed that the older backup files are not getting deleted with this method

(WITH COMPRESSION = 1, ERASEFILES = 2,VERIFY"')

when I took out the Verify out:
(WITH COMPRESSION = 1, ERASEFILES = 2"')

Files older than 2 days were deleted.

Is it a bug or I'm doing something wrong?

Jason Cook

Hi,
I'm afraid that it is indeed a problem with SQL Backup 5.0. We have already fixed the problem in the forthcoming 5.1 release (which should be released sometime next week), but in the meantime you can do one of the following to resolve the problem temporarily:

* Substitute ERASEFILES with ERASEFILES_ATSTART - the files will be deleted at the start of the backup rather than at the end, and will work correctly with the VERIFY keyword. In the user interface check the 'Delete prior to start of backup' box.

* Alternatively, If you are using the extended stored procedures directly or the command line, you can use the RESTORE VERIFYONLY syntax (described in the SQL Backup 5 help documentation) to perform a verification step after the backup.

Thankyou for raising the issue on the forums, and we apologise for any inconvenience it may have caused.

Thanks,
Jason