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:
Message
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.
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.
[font="Arial"]_______________________________________________________
Change is inevitable... Except from a vending machine.[/font] -
In SQL Server 2005 SQL Maint is now part of SSIS(SQL Server Integrated Services) and I think SSIS is not part of the Work Group edition. Check below for features compare.
http://www.microsoft.com/Sqlserver/2005/en/us/compare-features.aspx
Kind regards,
Gift Peddie -
It was working for a long while.
SSIS back end functionality is present in workgroup. What is not present is the custom package management tools. Maint tasks and manual imports are fine. Well should be anyway.
[font="Arial"]_______________________________________________________
Change is inevitable... Except from a vending machine.[/font] -
After much thinking 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.
[font="Arial"]_______________________________________________________
Change is inevitable... Except from a vending machine.[/font]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply