SQL Server backup failing with error code 0xC0024104 only at particular time

Question

SQL Server backup failing with error code 0xC0024104 only at particular time

viduvs

Ten Centuries

Points: 1026
More actions
November 3, 2014 at 6:36 am

#292172

Hi,
I have a Sharepoint databases - 2 instances running on the server Windows 2008 R2 Enterprise SP1 (64 bit). The SQL Server version is SQL Server 2008 R2 RTM - 64 bit.
On every instance, there are several databases, for which transaction log backup has been scheduled every 4 hours. Out of these schedules, only 1 transaction log backup is succeeding at 12:00 AM PST while other transaction log backup maintainace plans are failing at the same time. However these transaction log backups are succeeding at other times like 4:00 AM, 8:00 AM etc. These scheduled backup were running successfully till now and have started failing in this manner from yesterday - 2nd Nov.
Moreover, the backup task in all these mainatainance plans is succeeding and I can see the backup file created and it is giving error whille running 'maintenance cleanup' task as below:
Executed as user: '<domain user>'. Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 12:00:01 AM Progress: 2014-11-02 00:00:15.48 Source: {4B41C644-A173-47F3-812A-E93FEB8BA496} Executing query "DECLARE @GUID UNIQUEIDENTIFIER EXECUTE msdb..sp...".: 100% complete End Progress Progress: 2014-11-02 00:00:23.19 Source: Back Up Database Task Executing query "BACKUP LOG [<database_name>] TO DISK = N'I:\Sh...".: 50% complete End Progress Progress: 2014-11-02 00:00:24.17 Source: Back Up Database Task Executing query "declare @backupSetId as int select @backupSetId =...".: 100% complete End Progress Error: 2014-11-02 00:00:38.83 Code: 0xC0024104 Source: Maintenance Cleanup Task Description: The Execute method on the task returned error code 0x80131904 (Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.). The Execute method must succeed, and indicate the result using an "out" parameter. End Error Progress: 2014-11-02 00:00:48.75 Source: Notify Operator Task Executing query "EXECUTE msdb.dbo.sp_notify_operator @name=N'SQL DB...".: 100% complete End Progress DTExec: The package execution returned DTSER_FAILURE (1). Started: 12:00:01 AM Finished: 12:00:49 AM Elapsed: 47.531 seconds. The package execution failed. The step failed.
Can anyone please tell me the reason behind this and how to resolve this?
Thanks in advance.

Viewing 5 posts - 1 through 4 (of 4 total)

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

spaghettidba SSC Guru Points: 105732 More actions · Answer 1

...Timeout expired...

Looks like you have a timeout set to something other than 0 on your cleanup task in the maintenance plan. Can you confirm?

-- Gianluca Sartori

viduvs Ten Centuries Points: 1026 More actions · Answer 2

I have not explicitely setup anything. Can you please tell me where to check it?

Thanks for prompt response.

spaghettidba SSC Guru Points: 105732 More actions · Answer 3

Open the maintenance plan and select the cleanup task.

In the properties window you should see the "Timeout" property. How is it set?

-- Gianluca Sartori

viduvs Ten Centuries Points: 1026 More actions · Answer 4

I did check the timeout value for this task and it is 0.

However the jobs are going through successfully now.

May be for that time period something might happened to the server.

Thanks for your assistance.