Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

1 Answer

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
add comment

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.