Clean up 'Txt' File on Maintenance plan

Question

Clean up 'Txt' File on Maintenance plan

Susan S

SSCommitted

Points: 1771
More actions
October 17, 2007 at 4:49 pm

#119046

I create a clean up maintenance plan for deleting 'Txt' file report
I am using SQL 2005 SQL Server 9.0.3042
when I check it the result says ' It is successfull'
so to make sure, I go to the MSNAVCLDBBackup folder and I still can see all my report txt file dated 4 Oct 2007
I am confused what it has been deleted then?????
how do I check or see it?
what do I do wrong here?
anyone can advise me on this?
in my maintenance, I setup as below
Connection ; local server connection
Delete files: Maintenance Plan text reports
Search folder and delete files based on an extension: \\dcdump\MSNAVCLDBBackup'
File extension : txt
Age: Older than 2 Weeks
Task start: 2007-10-18T05:00:06.
Task end: 2007-10-18T05:01:29.
Success
Command:EXECUTE master.dbo.xp_delete_file 1,N''\\dcdump\MSNAVCLDBBackup'',N''txt'',N''2007-10-04T05:00:06''
Thanks,
Susan

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 1

I'm having the same issue on one of my SQL Servers. There are numerous forum postings about xp_delete_file (which is what the clean up task actually uses). It's an undocumented stored procedure that seems extremely flaky. Most of the work arounds involve writing your own scripts. At this point, that's the direction I'm going towards.

K. Brian Kelley
@kbriankelley

rlondon SSCarpal Tunnel Points: 4653 More actions · Answer 2

There is a cumulative upgrade package from Microsoft that will fix this problem. Look at the following links.

http://support.microsoft.com/kb/938085

http://support.microsoft.com/kb/936305

Susan S SSCommitted Points: 1771 More actions · Answer 3

If I am doing the work around and delete the ' NEW COMPONENT OUTPUT'

which one I should delete it. I have several txt file which are dated 4 oct.

and I notice when I delete that word and save it back the date is changed to today date.

has anyone apply the hot fix or wait till the final hot fix

Thanks

rlondon SSCarpal Tunnel Points: 4653 More actions · Answer 4

I have applied the hotfix and have not run into any problems yet.

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 5

There's a new cumulative update out just last week. I've requested and received it from Microsoft, but haven't applied it yet.

Cumulative update package 4 for SQL Server 2005 Service Pack 2

K. Brian Kelley
@kbriankelley