Minatanace plan for backup

Question

Minatanace plan for backup

Viewing 3 posts - 31 through 32 (of 32 total)

You must be logged in to reply to this topic. Login to reply

nbaghm SSC Veteran Points: 225 More actions · Answer 1

No it doesn't give any error, and every thing is going OK , during updating ..

Rob Fisk SSCommitted Points: 1861 More actions · Answer 2

I am having the same issue. I used to have a working maintenance plan but it started failing ages ago. I have been a tad lax in looking at it so I thought I'd delete it and use the wizard to create it from scratch:

Started: 14:59:02 Error: 2008-12-09 14:59:03.88 Code: 0xC0010018 Source: Update Statistics Description: Error loading a task. The contact information for the task is "Update Statistics Task; Microsoft Corporation; Microsoft SQL Server v9; © 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1". This happens when loading a task fails. End Error Error: 2008-12-09 14:59:03.90 Code: 0xC0010018 Source: Back Up Database (Full) Description: Error loading a task. The contact information for the task is "Back Up Database Task; Microsoft Corporation; Microsoft SQL Server v9; © 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1". This happens when loading a task fails. End Error Error: 2008-12-09 14:59:04.01 Code:... The package execution fa... The step failed.

After reading this post I decided to drop it and recreate it from MS directly on the server rather than remotely.

This was the same except: The contact information for the task is ""

Studio version: 9.00.3042.00 both locally and remotely.

[font="Arial"]_______________________________________________________
Change is inevitable... Except from a vending machine.[/font]

Ignacio A. Salom Rangel SSC-Insane Points: 20443 More actions · Answer 3

Try to install the workstation tools on your PC an then install SP2 on it (Workstation). The next step will be trying to create the MAintenance plan from your desktop after the workstation tools and SP2 are installed. Good luck!

My blog