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

Problem erasing old files

antounbantounb Posts: 2
edited May 25, 2007 12:12PM in SQL Backup Previous Versions
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?

Comments

  • Options
    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
Sign In or Register to comment.