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-09 : 05:52:27

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-10 : 02:42:02

Please share your SQL written in Job Step.

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

SaurabhSharan
Starting Member

9 Posts

Posted - 2012-07-20 : 03:21:20

I didnt get that

Saurabhsharan

lionofdezert
Aged Yak Warrior

885 Posts

Posted - 2012-07-20 : 08:26:13

Install Service Pack 4 for SQL Server 2005

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

jeffw8713
Aged Yak Warrior

819 Posts

Posted - 2012-07-22 : 11:14:15

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.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources