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.
| Author |
Topic |
|
snoopyyu
Starting Member
3 Posts |
 Posted - 2007-09-19 : 16:51:52
|
| I created a database maintenance plan on sql server 2005 (standard SP2, cluster environment). The plan created successfully on scheduled successfully. But when execute the plan, it fails. Here is the information in the log:The last step to run was step 1 (TranLog backup).,00:00:01,0,0,,,,009/19/2007 12:06:38,Tranlog backups.TranLog backup,Error,1,LAIWWORKSITE1\LA,Tranlog backups.TranLog backup,TranLog backup,,Executed as user: STROOCK\SQLSRV. Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 12:06:38 PM Warning: 2007-09-19 12:06:39.27 Code: 0x80012017 Source: Tranlog backups Description: The package path referenced an object that cannot be found: "\Package\TranLog backup.Disable". This occurs when an attempt is made to resolve a package path to an object that cannot be found. End Warning DTExec: Could not set \Package\TranLog backup.Disable value to false. Started: 12:06:38 PM Finished: 12:06:39 PM Elapsed: 0.688 seconds. The package execution failed. The step failed.,00:00:01,0,0,,,,0Any ideas? Thanks. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-19 : 23:18:27
|
| I'll apply post sp2 hotfix in this case, sp2 has lot of maintenance plan related bugs. |
 |
|
|
|
|
|
|
|
SQL Server 2005 Maintenance Plan failed to run