We help IT Professionals succeed at work.

dbo.xp_delete_file in sql server 2005 maintenance plan not deleting in sub folders

Taitor asked
Last Modified: 2012-05-08
I have a SQL Server 2005 maintenance plan that is supposed to delete old backups with a .bak extension but it only deletes the .bak files in the folder i specify not the sub folders within it.  I know at one point it used to delete the sub folders.  How can i get it to delete the old files in the sub folders as well because i have like 20 sub folders and i would prefer not to have to have 20 calls.  thanks.  
Watch Question

This one is on us!
(Get your first solution completely free - no credit card required)


Thanks.  I was not seeing that when i was looking at the maintenance plan from my management studio running on my pc.  i think i needed to do a service pack upgrade after reinstalling on my pc.  
That's possible.  If you have management studio installed on the server, you could try opening the maintenance plan from there and see if you see the check box.


Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.