Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2009
    Posts
    5

    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:

    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:
    http://stuff.robfisk.com/mainterror.gif

    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

  2. #2
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696
    Can you manually backup the database from a sqlcmd session ? Is the plan using sqlmaint or backup database ?

  3. #3
    Join Date
    Feb 2009
    Posts
    5
    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.

  4. #4
    Join Date
    Feb 2009
    Posts
    5
    I could find no help anywhere about this issue but fortunately Service pack 3 seems to have done a repair job for me.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •