The ranting of an IT Professional

Mar 2 2009   2:16PM GMT

SQL server not deleting files as part of Database Maintenance Plan



Posted by: Jason Tramer
Tags:
bak
Database maintenance plan
SQL
SQL server not deleting files as part of Database Maintenance Pla

I have actually seen this issue now twice in a two week span at different clients with the same resolution so either it’s a common issue or it’s just a coincidence. In this scenario the database maintenance plan is set to delete old backup jobs, the job completes but the files are not deleted. In both cases the fix was simple, in the plan it asks you to specify the file extention it should delete which in most cases is bak. Make sure when you are entering this yyou enter JUST bak, not .bak or “bak” or anything else. If you have any charachters (including spaces) other than just the letters bak it will not work.

Hope this helps you

 Comment on this Post

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: