SQL Server 2005 management Studio Autobackup Issue

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 2005 Forums

SQL Server Administration (2005)

SQL Server 2005 management Studio Autobackup Issue

Author

Topic

SaurabhSharan
Starting Member

9 Posts

Posted - 2012-07-20 : 07:53:45

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

SaurabhSharan
Starting Member

9 Posts

Posted - 2012-07-20 : 08:04:37

CAN ANY BODY PLEASE HELP MEEEEEEEEEEEEEEEEEE
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
[/quote]

Saurabhsharan

lionofdezert
Aged Yak Warrior

885 Posts

Posted - 2012-07-20 : 08:25:01

duplicate post http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=176568

--------------------------
http://connectsql.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources