SQL MAINTENANCE PLAN FAILING

  • BACKUP-USER DATABASES.Backup user databases,Error,1,TUCGPSQL-PROD\TUCGPSQL,BACKUP-USER DATABASES.Backup user databases,Backup user databases,,Executed as user: ENTERPRISE\#SharedSQL_Prod_VCS. ... for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 8:11:00 PM Error: 2008-06-08 20:11:16.33 Code: 0xC00291EC Source: {DA51E043-7B20-4B4A-BE1D-927D818512D7} Execute SQL Task Description: Failed to acquire connection "Local server connection". Connection may not be configured correctly or you may not have the right permissions on this connection. End Error Warning: 2008-06-08 20:11:16.33 Code: 0x80019002 Source: OnPreExecute Description: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors. End Warning Progress: 2008-06-08 20:11:17.74 Source: Back Up Database (Full) Executing query ... The package execution fa... The step failed.,00:26:13,0,0,,,,0

  • Is SQL agent sevice account has the access to sql and has right password?

    Looks to be it is access/permissions issue.

    MohammedU
    Microsoft SQL Server MVP

  • thanks

    But five days maintenance plan properly working but last 2 days is failing but the backup which includes in the maintenance plan is working but the removing of old files is not working.

  • Hi,

    Did you solve your problem?

    If so, could you tell how?

    I'm getting the same error message but can't find the solution anywhere on the internet. Only see several people having the same problem.

    I'm using the sa user and it's been working for weeks but suddenly stopped working. I'm sure we have done something what broke it but have no idea what :unsure:

    Kind regards

    Kim Bennik

  • only solution is wait for next days the job will run successfully.if not then still wait of one days more.

  • navin_vasnani (7/18/2008)


    only solution is wait for next days the job will run successfully.if not then still wait of one days more.

    What kind of response is that? :crazy:

    Check your permissions on the share that you're backing up to. The account running the SQL Agent must have full rights to that share if you're backing up and trying to delete older files using a MP. Sounds like someone changed permissions (or maybe passwords??).

    -- You can't be late until you show up.

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply