Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Maintenance Cleanup task does not delete files

Author  Topic 

Clint Eastwood
Starting Member

1 Post

Posted - 2010-04-14 : 09:40:42
Hi forum,

I have a weird problem with a cleanup task. Maybe someone can help me.

I created a maintenance cleanup task to delete old bak, trn and txt files. The ones which delete bak and trn are working properly, but the cleanup task doesn't delete any txt file.

Log files tell me the task was successfully, but files weren't deleted.

I checkes path and file extension, but the task configuratiobn looks good.

DBA in the making
Aged Yak Warrior

638 Posts

Posted - 2010-04-14 : 10:07:22
I know what you're thinkin', "Did he delete 6 txt files or only 5"? :)

Seriously though, are the text files open? Just a guess here, but that might be why they're not being deleted.

------------------------------------------------------------------------------------
Any and all code contained within this post comes with a 100% money back guarantee.
Go to Top of Page
   

- Advertisement -