DB Full Backup Job Failing with Maintenance Plan

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

DB Full Backup Job Failing with Maintenance Plan

Author

Topic

vijay1234
Starting Member

48 Posts

Posted - 2014-08-14 : 05:47:21

Hi All,

I have a scheduled Full back job with Maintenance Plan.

Though the back ups are being done successfully. The job is getting failed & below the error.

Message
Executed as user: POLYCOMRP\reporting. Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 64-bit Copyright (C)
Microsoft Corporation 2010. All rights reserved. Started: 12:13:10 AM Error: 2014-08-14 00:13:10.99
Code: 0xC002F210 Source: {DD3BA1A1-F41F-4648-BD0A-44D62B992099} Execute SQL Task
Description: Executing the query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp..." failed with the following error:
"The INSERT statement conflicted with the FOREIGN KEY constraint "FK_sysmaintplan_log_subplan_id". The conflict occurred in database "msdb",
table "dbo.sysmaintplan_subplans", column 'subplan_id'. The statement has been terminated.". Possible failure reasons: Problems with the query,
"ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. End Error Error: 2014-08-14 00:14:02.74
Code: 0xC0024104 Source: Back Up Database (Full) Description: The Execute method on the task returned error code 0x80131501
(An exception occurred while executing a Transact-SQL statement or batch.). The Execute method must succeed, and indicate the result using an "out" parameter.
End Error Error: 2014-08-14 00:14:02.75 Code: 0xC0024104 Source: {6E4B8395-8E69-4E1E-A18E-165406134E8A}
Description: The Execute method on the task returned error code 0x80131501 (An exception occurred while executing a Transact-SQL statement or batch.).
The Execute method must succeed, and indicate the result using an "out" parameter. End Error DTExec: The package execution returned DTSER_FAILURE (1).
Started: 12:13:10 AM Finished: 12:14:02 AM Elapsed: 52.109 seconds. The package execution failed. The step failed.

Do provide some suggestions on how to make this success.

Thanks in Advance

Regards,
Vijay

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-08-14 : 17:25:39

Looks like a maintenance plan bug. I would check your version (build number) and see if you are downlevel. I would bet you are missing a critical service pack and/or hotfix.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources