Log Backup Job fails however backups are created

  • I have a Maintenance Plan job that takes log backups of the User databases. Most of the time it runs successfully. Every now and then, it sends out a failure notification, however the log for the job shows success for the two tasks and the job has created all the log backup files. This is the message in the job step history:

    End Progress Error: 2008-07-26 12:15:41.04 Code: 0xC0024104 Source: Reporting Task for subplan-{08F57368-7039-4250-9BA3-AB97CEE97007} Description: The Execute method on the task returned error code 0x80131931 (Data is Null. This method or property cannot be called on Null values.). The Execute method must succeed, and indicate the result using an "out" parameter. End Error Error: 2008-07-26 12:15:41.04 Code: 0xC0024104 Source: Reporting Task for subplan-{0921A72F-E46C-4023-847C-B30E1D8382EA} Description: The Execute method on the task returned error code 0x80131931 (Data is Null. This method or property ca... The package execution fa... The step failed.

    I am running SQL Server 2005 Standard Edition SP2 CU6 (version 9.0.3228) on a 32-bit Windows Server 2003 Standard Edition SP2. The Log Backup Subplan only has 2 tasks: Maintenance Cleanup Task and Back Up Database Task.

    Have any of you experienced this before? I don't want the job to send out failure notifications to the support team when it is successfully completing the tasks. What should I do to correct this?

  • Make sure you maintenance plan logs to the file system so you get more details. We can help if you don't understand them.

  • My Maintenance Jobs do write out log files to the file system. The log file reports success when the job fails. This is the message in the job:

    uted as user: xxxxxxx\xxxxxxxxxxx. ....00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 3:15:01 PM Progress: 2008-11-07 15:15:06.50 Source: {95299DA7-BA58-4D80-BC40-066F8861E065} Executing query "DECLARE @GUID UNIQUEIDENTIFIER EXECUTE msdb..sp".: 100% complete End Progress Error: 2008-11-07 15:15:07.33 Code: 0xC0024104 Source: Reporting Task for subplan-{08F57368-7039-4250-9BA3-AB97CEE97007} Description: The Execute method on the task returned error code 0x80131931 (Data is Null. This method or property cannot be called on Null values.). The Execute method must succeed, and indicate the result using an "out" parameter. End Error Error: 2008-11-07 15:15:07.33 Code: 0xC0024104 Source: Reporting Task for subplan-{0921A72F-E46C-4023-847C-B30E1D8382EA} Description: The Execute method on the task returned error code 0x80131931 (Data is Null. This method or property can... The package execution fa... The step failed.

    This is the message in the log file (not the log backup file - although they are being created successfully as well):

    NEW COMPONENT OUTPUT

    Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.3228

    Report was generated on "TRGAZCPDST02".

    Maintenance Plan: User Databases

    Duration: 00:00:03

    Status: Succeeded.

    Details:

    Maintenance Cleanup Task (TRGAZCPDST02)

    Task start: 2008-11-07T03:15:05.

    Task end: 2008-11-07T03:15:06.

    Success

    Back Up Database Task (TRGAZCPDST02)

    Task start: 2008-11-07T03:15:07.

    Task end: 2008-11-07T03:15:08.

    Success

    This happens intermittently on different servers and is a production support issue. It is not a space issue - i have checked on that. I do not want our on-call DBA's to receive failure notifications on jobs that actually run successfully.

    Has anyone else have this issue? How did it get fixed?

  • I am having a similar issue. The error message is the same. The operation is for index re-org. Any idea anyone?

  • Dear Sir,

    I have created batch file for daily backup but I am not able to execute the same. Can you please let me know what further I have to insert in my exisiting querry. I request you please check my querry with batch file.

    BR

    Dinesh

    <backup.batch>

    BACKUP DATABASE [QCONSULTLTD] TO DISK = N'D:\Backup\Saga pastel bkup\Wednesday\Qconsultltd_Wed.bak' WITH NOFORMAT, NOINIT, NAME = N'QCONSULTLTD-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10

    GO

    BACKUP DATABASE [QGL] TO DISK = N'D:\Backup\Saga pastel bkup\Wednesday\Qgl_Wed.bak' WITH NOFORMAT, NOINIT, NAME = N'QGL-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10

    GO

    BACKUP DATABASE [EvolutionCommon] TO DISK = N'D:\Backup\Saga pastel bkup\Wednesday\EvolutionCommon_Wed.bak' WITH NOFORMAT, NOINIT, NAME = N'EvolutionCommon-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10

    GO

  • I am receiving the same error during log backups. The log file is created but receive Error Code: 0xC0024104. Has anyone found out why this happens?

  • d.chhabra (11/4/2009)


    Dear Sir,

    I have created batch file for daily backup but I am not able to execute the same. Can you please let me know what further I have to insert in my exisiting querry. I request you please check my querry with batch file.

    BR

    Dinesh

    You are hijacking this thread with a different problem. You'll get better help if you start a thread specific to your problem.

  • As for answers to the original post and my reply posted yesterday, it looks like my problem had to do with a Raid controller failure. I was told that rebooting the server would resolve my original issue, but when the server was rebooted it would not come up again. Now we need to order a new raid controller to get it back up again. So check your hardware and see if that is causing your errors.

  • I am receiving the same error during log backups.

    It was on Windows 2003 Server' with 'Microsoft SQL Server Enterprise Edition (64-bit)' version '9.00.4053.00'.

    In EventLog are next records:

    Event Type:Error

    Event Source:McLogEvent

    Event Category:None

    Event ID:5051

    Date:13.07.10

    Time:00:41:48

    User:NT AUTHORITY\SYSTEM

    Computer:AMPSV02806PRD

    Description:

    A thread in process C:\Program Files (x86)\McAfee\VirusScan Enterprise\x64\mcshield.exe took longer than 90000 ms to complete a request.

    The process will be terminated. Thread id : 53608 (0xd168)

    Thread address : 0x0000000077EF0D1A

    Thread message :

    Build VSCORE.13.3.2.137 / 5400.1158

    Object being scanned = \Device\HarddiskVolume1\Program Files (x86)\IBM\Director\cimom\logs\SmartInterface.log

    by C:\Program Files (x86)\Common Files\IBM\icc\cimom\bin\wmippa.exe

    17018(281)(0)

    17017(0)(1)

    7007(0)(0)

    5006(0)(0)

    5004(0)(0)

    5003(0)(0)

    5002(0)(1)

    15002(0)(0)

    Event Type:Error

    Event Source:McLogEvent

    Event Category:None

    Event ID:1008

    Date:13.07.10

    Time:00:42:11

    User:N/A

    Computer:AMPSV02806PRD

    Description:

    The McShield service terminated unexpectedly.

    Please review event 5019 or 5051 for details. The McShield service will be restarted in 60 seconds;

    Event Type:Error

    Event Source:SQLISPackage

    Event Category:None

    Event ID:12291

    Date:13.07.10

    Time:00:42:12

    User:NT AUTHORITY\SYSTEM

    Computer:AMPSV02806PRD

    Description:

    Package "Backup TLOG BWP" failed.

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

    Event Source:McLogEvent = 'McAfee VirusScan' (Enterprise + AntiSpyware Enterprise v8.5i).

    So I suspect 'McAfee VirusScan' as root cause of this issue.

Viewing 9 posts - 1 through 8 (of 8 total)

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