SQL Server - Backup Maintenance job failing (-1073548784)

Asked By aruna g on 10-Jan-10 12:32 AM

Hi

Am getting following error for a job scheduled for DB maintenace plan which includes integrity chk, reorganise, shrink databsse task and Backup full databases:

I checked in google completly not nothing worked. Also let me know how defined a Folder path in the Define Maintanence Cleanup Task in sql server

Failed:(-1073548784) Executing the query "EXECUTE master.dbo.xp_delete_file
0,N'',N'',N'2009-12-13T00:00:15'
" 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.


EXECUTE msdb..sp".: 100% complete  End Progress  Error: 2026-01-10 04:35:40.76
Code: 0xC002F210 Source: Maintenance Cleanup Task Execute SQL Task Description: Executing the query "EXECUTE master.dbo.xp_delete_file 0,N'',N'',N'2009-12-13T04:35:40'  " 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.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  04:35:26  Finished: 04:35:41 

Thanks in advance


re- Backup Maintenance job failing (-1073548784) - DL M replied to aruna g on 10-Jan-10 03:41 AM

For Error (-1073548784) Executing the query http://support.microsoft.com/kb/946036
http://vittoriop77.blogspot.com/2007/09/sql-2005-backup-error-1073548784.html  http://blogs.technet.com/josebda/archive/2006/07/31/maintaining-your-moss-2007-sql-databases.aspx

for Code: 0xC002F210 Source: Maintenance Cleanup Task Execute SQL Task Description: Executing the query "EXECUTE master.dbo.xp_delete_file

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 it's a database maintenance plan report or not. If the first line reads, "NEW COMPONENT OUTPUT," the "xp_delete_file system" stored procedure cannot recognize the report as a database maintenance plan report.


Solution:
To resolve this problem, obtain Cumulative Update Package 2 for SQL Server 2005 Service Pack 2. The Microsoft Knowledge Base article on how to obtain Cumulative Update Package 2 is here:

936305 (http://support.microsoft.com/kb/936305/) Cumulative Update Package 2 for SQL Server 2005 Service Pack 2

To work around this problem, delete the first line of the report if the first line is, "NEW COMPONENT OUTPUT." The report will be deleted the next time you use the clean-up task

http://kbalertz.com/Feedback.aspx?kbNumber=938085




Jonathan VH replied to aruna g on 10-Jan-10 09:33 AM

That looks as though you left both the Folder and Extension fields blank when you configured the Maintenance Plan Cleanup Task. Typically, one would enter someting like this in the Folder text box:

G:\MSSQL\BACKUP

and something like this in the Extension text box:

BAK