Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 SQL Server 2005 Issue
 Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

9 Posts

Posted - 07/09/2012 :  04:19:46  Show Profile
HI All ,

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 -
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;;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.

PLease let me know what will be issue.


Most Valuable Yak

15732 Posts

Posted - 07/20/2012 :  07:35:56  Show Profile  Visit robvolk's Homepage
Please do not cross post:
Go to Top of Page
  Previous Topic Topic Next Topic  
 Topic Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000