Maintenance Cleanup Plan not deleting bak/trn files in subfolders when option is checked

Question

Running SQL Server 2008 v 10.2.4064.0

Maintenance Cleanup Plan set to delete bak/trn files older than 8 days. Backup folder is "D:\SQL\Backup" with subfolders for each DB residing within this folder. The option "Include First Level Subfolders" is checked but none of the files older than 8 days in the subfolders are being deleted. I'm sure this has been asked before so I apologize however the only searches I have found related SQL Server 2005.

Regards

Scott

Answer 1

Hi Scott,

only one level down would be cleaned up.

---

Arthur My Blog

Answer 2

Hi,

In addition to Arthur's comment, as per: http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/633a8710-0579-4219-824d-5c35481e5ccb, if you have one, take the "." from .bak and .trn

---

Thanks,

Andrew Bainbridge
SQL Server DBA

Please click "Propose As Answer" if a post solves your problem, or "Vote As Helpful" if a post has been useful to you