error number -1073548784 on MS SQL 2012 executing maintenance subplan command
Account Home | Help | Blog | Contact us | Log Out

Welcome to Kbytes > Articles

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:
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,
This should run in Query window now.
There are two screens this information should have been entered:
If you forgot to enter the details there, then you can look at the properties of the job and add them later:

blog comments powered by Disqus

Kbytes Home | Privacy Policy | Contact us | Testing Area

© 2004 - 2024 1 Oak Hill Grove Surbiton Surrey KT6 6DS Phone: +44(020) 8123 1321