Database backup/restore history gone
Surinder
Posts: 44 Bronze 2
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?
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?
Shin..
Comments
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
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.