Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Maintenance Plan corrupted – Backup Plan? Expand / Collapse
Author
Message
Posted Friday, August 23, 2013 12:02 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 10:17 PM
Points: 1,049, Visits: 2,957
Hi,

Daily backup plan was failed when start the Backup Jobs. It was successful after restart the server, what could be reason? Why SSIS packages get it corrupted and not loading during start the Job?

Error Mesages


Microsoft (R) SQL Server Execute Package Utility Version 10.0.2531.0 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 8:47:09 AM Error: 2013-08-21 08:47:09.65 Code: 0xC0010018 Source: Description: Error loading value "<DTS:ConnectionManager xmlns:DTS="www.microsoft.com/SqlServer/Dts"> <DTS:Property DTS:Name="DelayValidation">0</DTS:Property> <DTS:Property DTS:Name="ObjectName">Local server connection</DTS:Property> <DTS:Property DTS:Name="DTSID">{0BC551FA-4FAF-4EB2-8" from node "DTS:ConnectionManager". End Error Could not load package "Maintenance Plans\DB_BACKUP" because of error 0xC0010014. Description: One or more error occurred. There should be more specific errors preceding this one that explains the details of the errors. This message is used as a return value from functions that encounter errors. Source: Started: 8:47:09 AM Finished: 8:47:09 AM Elapsed: 0.406 seconds. The package could not be loaded. The step failed.

Thanks
ananda
Post #1487645
Posted Friday, August 23, 2013 9:32 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, July 14, 2014 2:06 PM
Points: 3,865, Visits: 7,130
Is there any chance these jobs were created on a 64-bit server? If so, please check this link: http://www.sqlservercentral.com/Forums/Topic737169-148-1.aspx#bm1420339

______________________________________________________________________________
"Never argue with an idiot; They'll drag you down to their level and beat you with experience"
Post #1487882
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse