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

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 SQL Server 2005 management Studio Autobackup Issue

Author  Topic 

SaurabhSharan
Starting Member

9 Posts

Posted - 2012-07-20 : 07:54:39
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 -
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.

PLease let me know what will be issue.

Saurabhsharan

lionofdezert
Aged Yak Warrior

885 Posts

Posted - 2012-07-20 : 08:22:32
duplicate post http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=176568
Go to Top of Page
   

- Advertisement -