I have installed SQL Server 2005 studio management. I am trying to set autobackup schedule which is getting error. Error - 1st - Message The job failed. The Job was invoked by User SUPPORT1\my. The last step to run was step 1 (Subplan_1). 2nd - Message Executed as user: SUPPORT1\SYSTEM. ...on 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 12:54:07 PM Error: 2012-07-09 12:54:09.76 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 Progress: 2012-07-09 12:54:10.20 Source: {91A78BE3-5A3A-498E-B31C-07C4A6AED034} Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp".: 100% complete End Progress Error: 2012-07-09 12:54:10.42 Code: 0xC0024104 Source: Back Up Database (Full) Description: The Execute method on the task returned error code 0x80004003 (Collection cannot be null. Parameter name: c). The Execute method... The package execution fa... The step failed.
Right-click on the maintenance plan and select View History. That should show you which task actually failed - and the error associated with that task.
With that said, it looks like your client tools are not updated to the same version or greater than the server. Validate the client version (Help | About ) and the server version (SELECT @@VERSION). If the server version is greater than your client version you will get these kinds of errors.
SQL Server 2005 management Studio Autobackup Issue
Posted - 07/09/2012 : 05:52:27
