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

Issue with editing backup jobs

goldmedalgoldmedal Posts: 19
edited March 18, 2009 5:51AM in SQL Backup Previous Versions
SQL Backup 5.3.0.178 installed for our SQL Servers, with backups taken daily. However on one server backups older than 2 days are not being deleted. When looking at the job edit screen the box:

"Delete existing backup files in this folder for selected databases" is ticked and the backup retention is set for 2 days. However the:

"Delete proir to start of backup" IS NOT ticked - would this mean why databases older than 2 days are not being deleted?

Also on some servers when trying to edit a job schedule I receive the message "The GUI does not support editing the command you selected" Why is this?

Thanks in advance,

Scott

Comments

  • Options
    Hi Scott,

    'Delete existing backup files in this folder for selected database' (ERASEFILES) will delete only the backup files in the folder which are for this database and not any other database.

    In this case first the backup is done. After backup is finished, then the backup folder is checked and any backup file which are older than 2 days for this particular database will be deleted.

    'Delete prior to start of backup' (ERASEFILES_ATSTART) means that the backup folder is checked first and then any backup files for this database which are older than 2 days will be deleted. The backup starts after the deletion process.

    Please send us the log file if it is not working as desired.

    There are few backup commands which are not supported for editing in SQL Backup UI. So we display this ... 'GUI does not support editing the command you selected' .. message when SQL Backup UI doesn't support editing of the selected command. For e.g. if you have created a backup job for Filegroup backup in that case SQL Backup UI will display this message.

    Thanks,
    Priya
    Priya Sinha
    Project Manager
    Red Gate Software
Sign In or Register to comment.