Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Maintenance Cleanup Task Does Not delete old text files

Status
Not open for further replies.

JohnBates

MIS
Feb 27, 2000
1,995
US
hi everyone,

Using 2005 SP2

I have built several Maint plans to perform tasks such as deleting old .bak, .trn and .txt files

The Maint Plan reports (.txt files) seem to build up forever; the task doesn't remove them and I have to manually take care of them.

This is the T-SQL executed by 1 of my plans:
EXECUTE master.dbo.xp_delete_file 1,N'E:\MicrosoftSQLServer\Backups',N'txt',N'2009-02-11T16:56:22'

Is this a known issue? If it is a bug, does SP3 fix it?

Thanks, John

 
aha - I need to install Build 3175 (aka Cumulative Update package 2 for SP2)

Thanks, John
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top