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 |
|
Bodestone
Starting Member
18 Posts |
 Posted - 2009-02-06 : 05:33:44
|
I have Microsoft SQL Server Workgroup Edition version 9.00.3282.00My maintenance plan for backups worked when the server was first installed but at some point it failed. I have to bow my head in shame and admit that this was several months ago and I have been too busy to look at it until now. I have removed the existing plan and re-created one with just backup and file cleanup tasks but when executing it fails with the folowing log entry:MessageExecuted as user: BOVRIL\SYSTEM. ...Execute Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 10:29:40 Error: 2009-02-03 10:29:40.74 Code: 0xC0010018 Source: Back Up Database (Full) Description: Error loading a task. The contact information for the task is "". This happens when loading a task fails. End Error Error: 2009-02-03 10:29:41.04 Code: 0xC0010026 Source: Back Up Database (Full) Description: The task has failed to load. The contact information for this task is "". End Error Error: 2009-02-03 10:29:41.04 Code: 0xC0024107 Source: Back Up Database (Full) Description: There were errors during task validation. End Error Error: 2009-02-03 10:29:41.04 Code: 0xC0010025 Source: Backups Description: The package cannot execute because it contains tasks that failed to load. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 10:29:40. The step failed.When I go back and try to edit the step inside the plan I get a popup error saying that it is not registered for use on the computer:  If I do not use the wizard then any item I add to the plan produces this error when trying to edit its properties even though I have just added it.Any help on troubleshooting this would be a great help. Cheers |
|
|
Bodestone
Starting Member
18 Posts |
Posted - 2009-02-11 : 08:18:20
|
| After much thinking and no replies to this I pondered the possibility it was a corruption in the encryption keys. The symmetric keys for reporting services had become corrupt after a power outage some time ago though I am not sure if this coincided with the maintenance plan failure.I could find no help anywhere about this issue but fortunately Service pack 3 seems to have done a repair job for me. |
 |
|
|
|
|
|
Maintenance Plans will not run: Error loading task