Maintenance Plan (Clean up Job)

  • 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?

  • 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

  • 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