Unanswered: Maintenance Plans will not run: Error loading task
I have Microsoft SQL Server Workgroup Edition version 9.00.3282.00
My 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:
Executed 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.
Manual or scripted backup is fine. The problem seems to be that the maintenance plan tasks are not accessible once created possibly due to corrupt keys.
Having jad time to think about this there was a power outage a while back and the symmetric keys for reporting services were corrupted and had to be restored. I have cast around for topics on the text in the screenshot to no joy.