July 14, 2014 at 12:27 pm
I have a maintenance plan to delete files older than 3 days which runs once a night however there are files in each database folder that are older than three days. The "View Job History" shows that the job execute without any problems, I have checked the " Include first-level subfolders" and the radio button "Maintenace Clean Up Task" & " Clean up History". What would the issue be, is it that SQL doesn't delete sub directory folders?
July 14, 2014 at 12:37 pm
You might check to see if the files are valid backups (RESTORE HEADERONLY FROM DISK=N'questionedfiles'
. I have read at times if the backup is corrupt or in some other way not valid that the process will not actually delete the file.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
July 14, 2014 at 1:42 pm
The are, but it looks like the problems is that I have ".bak" instead of "bak" in the extension box.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply