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