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 "EXECUTE master.dbo.xp_delete_file 1,N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\sdtest.txt' " failed with the following error: "Error executing xp_delete_file extended stored procedure: Specified file is not a Maintenance Plan report file.". Possible failure reasons: Problems with the query, "ResultSet" 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.