Microsoft KB Archive/938085

= A clean-up task does not delete database maintenance plan reports after you install SQL Server 2005 Service Pack 2 =

Article ID: 938085

Article Last Modified on 11/20/2007

-

APPLIES TO


 * Microsoft SQL Server 2005 Developer Edition
 * Microsoft SQL Server 2005 Enterprise Edition
 * Microsoft SQL Server 2005 Standard Edition
 * Microsoft SQL Server 2005 Standard X64 Edition
 * Microsoft SQL Server 2005 Standard Edition for Itanium-based Systems
 * Microsoft SQL Server 2005 Enterprise X64 Edition
 * Microsoft SQL Server 2005 Enterprise Edition for Itanium-based Systems

-



Bug #: 50001017 (SQL Hotfix)



SYMPTOMS
After you install Microsoft SQL Server 2005 Service Pack 2 (SP2), you use a clean-up task in SQL Server 2005. However, the clean-up task does not delete database maintenance plan reports. Additionally, you receive an error message that resembles the following:

Error: 2006-12-06 16:52:39.92 Code: 0xC002F210 Source: Maintenance Cleanup Task 1 Execute SQL Task Description: Executing the query &quot;EXECUTE master.dbo.xp_delete_file 1,N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\sdtest.txt' &quot; failed with the following error: &quot;Error executing xp_delete_file extended stored procedure: Specified file is not a Maintenance Plan report file.&quot;. Possible failure reasons: Problems with the query, &quot;ResultSet&quot; property not set correctly, parameters not set correctly, or connection not established correctly. End Error Warning: 2006-12-06 16:52:39.92 Code: 0x80019002 ... The package execution fa... The step failed.



CAUSE
This problem occurs because the first line of the report contains the following text:

NEW COMPONENT OUTPUT

The xp_delete_file system stored procedure examines the first line of the report to determine whether the report is a database maintenance plan report. If the first line of the report is &quot;NEW COMPONENT OUTPUT,&quot; the xp_delete_file system stored procedure cannot recognize the report as a database maintenance plan report.



WORKAROUND
To work around this problem, delete the first line of the report if the first line of the report is &quot;NEW COMPONENT OUTPUT&quot;. After you do this, the report will be deleted the next time that you use the clean-up task.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

Keywords: kbtshoot kbprb kbexpertiseadvanced kbsql2005tool KB938085

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.