Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
sql server 2005 studio management autobackup issue

Answered sql server 2005 studio management autobackup issue

  • Friday, July 20, 2012 12:17 PM
     
     
    Sign In to Vote
    0
    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.
     

All Replies

  • Monday, July 23, 2012 4:22 PM
     
     
    Sign In to Vote
    0
    You might get more information by looking at the maintenance plan history.  If so, please post details.  Thanks,


    Thanks, Andrew

     
  • Tuesday, July 24, 2012 1:29 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Hi SaurabhSharan,

    You only applied SQL Server 2005 Service Pack 2. I suggest you install SQL Server 2005 Service Pack 4 to see if it would be work. Refer: http://support.microsoft.com/kb/982662.

    Try running the job with SQL Services ID as the job owner and see the result while changing it to sa.

    If you have any problem, please feel free to let me know.

    Thanks,
    Maggie

     

    Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.