Maintenance Cleanup task NOT deleting files

I have applied SP2 and my maintenance cleanup tasks are NOT deleting the files. I have ensured that the folder path is correct. I have also checked the 'age' setting and saved the package. I rebooted the server and ran the job and it still is not deleting the files.

What types of files are not being deleted? I've tested this with backup files (.bak), and it works. I vaguely remember another type of file does not get deleted. Please post more information and we'll figure out next steps.

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

|||

post the result of Select @.@.Version .... After release of SP2, MS has released some fixes for Matinenance Plan and if you have downloaded the SP2 before 05 mar ... then u need to apply those patches

Refer this link : http://support.microsoft.com/kb/933508

if the patch is already applied then the version should be : 9.0.3050.00

Madhu

|||

Yes, we had downloaded SP2 before March 5th, but we saw the release of 2a and have applied it also. The version is , Microsoft SQL Server 2005 - 9.00.3050.00 (Intel X86) Mar 2 2007 20:01:28 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4).

I have also applied 2a to my workstation so my tools version should also be correct.

|||

The file types are the maintenance plan output files, the .txt files. It's the default extension if you select 'maintenance plans files' in the clean up task. The version is Microsoft SQL Server 2005 - 9.00.3050.00 (Intel X86) Mar 2 2007 20:01:28 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4) .

Thanks for any help you can give me.

|||

Mel100 wrote:

The file types are the maintenance plan output files, the .txt files.

As I suspected, this is a known issue that we could not fix in time for Service Pack 2. We ensured that .bak files are deleted properly, but the .txt files are not. See below for the associated Microsoft Connect item. If this scenario is important to you, please vote on it.

https://connect.microsoft.com/feedback/viewfeedback.aspx?FeedbackID=259390&wa=wsignin1.0&siteid=68

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

|||Thanks so much for your help. This explains the task not deleting the files. I guess until this is fixed we will not use the Maintenance cleanup task.|||

I have a Maintenance Cleanup task that is not deleting bak files. The server connection is valid, the account for the connection is a local admin and the owner of the agent job is a local admin. Local admins have full control to the folder where the files are. Also both accounts have the SA role. I have tried the folder name with a \ at the end and without. The job executes and completes successfully, it just doesn't remove bak files from the folder. I am on SP1 = Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) Apr 14 2006 01:12:25 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

Any assistance would be appreciated, thanks.

|||

We have the same issue but not in SP2: ver:9.00.2047.00

The trn files are deleted, but the txt not !!