It seems that most of the SQL servers that I have monitored, that are using the built in maintenance backup program, over time, fail to follow the part of the plan that deletes old files after a set date.
A couple of examples.
One server, even though it was set to delete the files after a week, would just keep adding the files. After a month or two I would have to go in and manually delete the .bak files to gain the gigs of space back.
On another, the job worked for a very long time, then it started to not delete the files. If I rebooted the server when it stopped clearing the files, I would get a from one to four weeks were it works normally, then it stopped deleting them again, until the next reboot.
I make no claims that I know how SQL does its thing. I can muddle my way through getting it to do some maintenace routines as needed.
Any quick guesses for causes? Any hints as to fixes?
A couple of examples.
One server, even though it was set to delete the files after a week, would just keep adding the files. After a month or two I would have to go in and manually delete the .bak files to gain the gigs of space back.
On another, the job worked for a very long time, then it started to not delete the files. If I rebooted the server when it stopped clearing the files, I would get a from one to four weeks were it works normally, then it stopped deleting them again, until the next reboot.
I make no claims that I know how SQL does its thing. I can muddle my way through getting it to do some maintenace routines as needed.
Any quick guesses for causes? Any hints as to fixes?
