SQL Server maintenance plan not deleting backup files as anticipated
SS 2008 R2
When I checked our server this morning, I found that several of the backup processes had failed over the weekend and found the hard drive used for backups was full. I assumed that when I added a cleanup task to my weekly full backup, that it would properly delete all files of the type ".bak" residing in subfolders of D:\MSSQL\Backups\ which were older than 8 days, but that is not happening. This is what the Cleanup Task Dialog box looks like in SSMS:
Anybody have any ideas as to why it is not deleting the files as requested? If it makes any difference, the Maintenance Plan diagram looks like:
When I checked our server this morning, I found that several of the backup processes had failed over the weekend and found the hard drive used for backups was full. I assumed that when I added a cleanup task to my weekly full backup, that it would properly delete all files of the type ".bak" residing in subfolders of D:\MSSQL\Backups\ which were older than 8 days, but that is not happening. This is what the Cleanup Task Dialog box looks like in SSMS:
Anybody have any ideas as to why it is not deleting the files as requested? If it makes any difference, the Maintenance Plan diagram looks like:
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
lcohan
Also, I usually put the cleanup task first so the space is released back to use but that after I'm confident backups are there and cleanup works as expected.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for your quick response.