Deleting old backup files before the backup job commences.
Delete Backup Files older than a certain amount of days [...]
The program is used to remove obsolete backup files.
Date of filing must be stated explicitly in the name of the file.
The date is given as a string of digits with the following structure: YYYYMMDD
Example:
Arch20090205.bak
Arch20090311.bak
Program can call with 3 parameters:
A string denoting the path where the files are backup copies
The archive files used to describe the pattern
Allowed are metacharacters * and?
Requires a string: YYYYMMDD
Integer indicating the number of days of archived files. Today's date is the basis for the calculation: the file should be removed?
Example:
C:\>bakCleaner.exe "c:/backup" "archYYYYMMDD*.bak" 3
"F:\exe files\bakCleaner.exe" "c:\Program Files\Microsoft SQL Server\backup" "*YYYYMMDD????.bak" 7
The platform runs on Win 32bit and 64bit.
It can be run as a step in the job of SQL Server Agent (preferably immediately after executing step with backup proces)