Backup files not being deleted
This is the command thats being issued,
BACKUP DATABASE [myDB] TO DISK = 'H:\backup_share\<AUTO>.sqb' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', COPYTO = '\\SQL2\db', FILEOPTIONS = 7, ERASEFILES = 2, COMPRESSION = 2, THREADCOUNT = 7
By my reading SQL Backup should be erasing all files that are more than two days old in both the primary and COPYTO locations, which it is not doing. No files are being deleted at all.
If the command is not correct, please advise what I need to change so the command works.