ERROR MESAGGE:
“Executing the query “EXECUTE master.dbo.xp_delete_file 0,N”,N”,N’2007-11-14T13:06:42′ ” failed with the following error: “Error executing extended stored procedure: Invalid Parameter”. Possible failure reasons: Problems with the query, “ResultSet” property not set correctly, parameters not set correctly, or connection not established correctly. ”
EXPLANATION:
You receive this error if you leave the Folder value blank in a Maintanence Cleanup Task that you created in Maintanence Plan in SQL Server 2005.
The occurrence of the error is as follows:
– Open SSMS
– Go to Management from Maintanence Plans.
– Right click the Mailtanence Plan Wizard.
– Start creating a Maintanence Cleanup Task and if you leave the Folder blank when you reach the Define Maintanence Cleanup Task window, you will get this error.
SOLUTION:
When creating the Maintanence Cleanup Task, enter a valid path value(where you keep your database backups) in the Define Maintanence Cleanup Task window.
