error number -1073548784 on MS SQL 2012 executing maintenance subplan command

Posted By: siteadmin on 20/11/2012 09:56:00

While setting up the default maintenance plan for a server backup you may encounter error number -1073548784

With error message

Executing the query "EXECUTE master.dbo.xp_delete_file 0,N'',N'',N'2012..." 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.

and a link to the T-SQL command

EXECUTE master.dbo.xp_delete_file 0,N'''',N'''',N''2012-10-23T08:41:33'',1

A similar problem found here:

http://stackoverflow.com/questions/212603/sql-server-xp-delete-file-not-deleting-files

Anyway we got rid of the error by adding the path to the files to delete and the extension e.g.

EXECUTE master.dbo.xp_delete_file 0,

N'E:\MSSQL11.MSSQLSERVER\MSSQL\Backup',

N'bak',

N'2012-10-23T08:41:33',1

This should run in Query window now.

There are two screens this information should have been entered: