Database backup/restore history gone

Surinder

Hi..

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?

Chris Auckland

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

Surinder

Hi,

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.