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

Database backup/restore history gone

SurinderSurinder Posts: 44 Bronze 2
edited May 31, 2007 4:59AM in SQL Backup Previous Versions

I updated one of the backup jobs using SQLBackup 5 and set the option
"Delete existing backup files in this folder for the selected database " to 2 days.

When I checked the logs today, not only has it deleted the physical backup files, it as also wiped out all the history records up to the 22nd May.

Can anyone confirm if this is a bug or a feature?


  • Options
    Thanks for your message.

    It should be the frequency and date range set when running sp_deletebackuphistory, that determines how much of the backup history is deleted, rather than the erasefile option in a job. It might be worth checking the server option and see if that is also set to two days.

    This sp is configured in the server option 'delete old backup history'. You should be able to set the deletion period for each server to choose how much history is retained. To get to the option right-click the server name and select options.

    I hope this helps
  • Options
    SurinderSurinder Posts: 44 Bronze 2

    The option is already disabled. It seems to be working as expected now (ie. retaining the history). But for some reason there is still a hole in the history records.

    I have records:-
    31-05-2007 to 22-05-2007
    then a big hole until 23-10-2003, after which the history is as expected.
Sign In or Register to comment.