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

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 SQL Server 2005 management Studio Autobackup Issue
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

SaurabhSharan
Starting Member

India
9 Posts

Posted - 07/09/2012 :  05:52:27  Show Profile  Reply with Quote
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

Pakistan
885 Posts

Posted - 07/10/2012 :  02:42:02  Show Profile  Visit lionofdezert's Homepage  Send lionofdezert a Yahoo! Message  Reply with Quote
Please share your SQL written in Job Step.

--------------------------
http://connectsql.com/
Go to Top of Page

SaurabhSharan
Starting Member

India
9 Posts

Posted - 07/20/2012 :  03:21:20  Show Profile  Reply with Quote
I didnt get that

Saurabhsharan
Go to Top of Page

lionofdezert
Aged Yak Warrior

Pakistan
885 Posts

Posted - 07/20/2012 :  08:26:13  Show Profile  Visit lionofdezert's Homepage  Send lionofdezert a Yahoo! Message  Reply with Quote
Install Service Pack 4 for SQL Server 2005

--------------------------
http://connectsql.blogspot.com/
Go to Top of Page

jeffw8713
Aged Yak Warrior

USA
798 Posts

Posted - 07/22/2012 :  11:14:15  Show Profile  Reply with Quote
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.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.2 seconds. Powered By: Snitz Forums 2000