Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm trying to run a Maintenance Cleanup Task to remove .bak files older than 2 days (simple enough).

Been trying all variety of .bak, BAK, .*., and editing the path, but the files are still not getting removed even though I receive a "job succeeded" log message.

I'm not at the point where I believe it's a folder permission issue.

How do I make sure my SA has the proper permissions to remove files from a folder?

Thanks.

share|improve this question

You need to ensure that the domain (or local) Windows account that the SQL Server and the SQL Server Agent services run under have the rights needed to delete the files.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.