Backup files not deleting when using the SQL Maintenance plan

  • I have created a SQL Server Maintenance plan to first created a backup the databases nightly and then delete any file other than three days. The backups are successfully being created however the backup files older then three days are not being delete. I have done the same simple procedure in the past in other database server it just not working on this one. I am not receiving any fail alerts on any sort. ???

  • what options have you set on the cleanup task?

    told it to transvers subfolders if you have 1 cleanup task for all database backups?

  • Below are my settings

    Delete files of the following types: Backup files

    File Location: "x:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup"

    File extension: bak

    (Checked) Delete file based on the age of the file at task run time

    Delete files older than the following: 3 day(s)

  • do all backups, backup to that directory or to subdirectories?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply