February 19, 2013 at 8:47 am
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. ???
February 19, 2013 at 8:49 am
what options have you set on the cleanup task?
told it to transvers subfolders if you have 1 cleanup task for all database backups?
February 19, 2013 at 9:02 am
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)
February 19, 2013 at 9:56 am
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