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
 
GO
 
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:
 
 
 
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 - 2018 1 Oak Hill Grove Surbiton Surrey KT6 6DS Phone: +44(020)82617371