December 8, 2010 at 9:21 pm
Dear All,
Can some one help me out from this issue.
Step ID1
ServerXXXXXXXX
Job Name XXXXXX-Tlogbck.Subplan_1
Step NameSubplan_1
Duration00:00:56
Sql Severity0
Sql Message ID0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0
Message
Executed as user: XXXXXX\SYSTEM. ....00.4035.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 12:01:37 PM Progress: 2010-12-07 12:01:39.82 Source: {64938F1A-1EAF-49E6-9CD3-D840D1388881} Executing query "DECLARE @GUID UNIQUEIDENTIFIER EXECUTE msdb..sp".: 100% complete End Progress Error: 2010-12-07 12:02:14.88 Code: 0xC0024104 Source: Back Up Database (Transaction Log) 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 Error: 2010-12-07 12:02:29.90 Code: 0xC0024104 Source: {CF6DF2DB-0ED9-48C5-995A-D465233EBA67} Description: The Execute method on the task returned error code 0x80131904 (Timeout expired. The timeout period elapsed prior to ... The package execution fa... The step failed.
"Eventid 12291 - Package "XXXX-Tlogbck" failed."
Thanks and Regards,
Ravichandra.
December 8, 2010 at 9:33 pm
Are you backing up locally, or to an unavailable file server?
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
December 8, 2010 at 9:40 pm
can you post the contents of the log file which would have been generated for this job at location that you specifed. by default you can see this in C:\program files\microsoft sql server\mssql.1\log, name of your job + date + time.txt
December 8, 2010 at 10:30 pm
Right click the Maintenance Plan and select "View History". If that does not have enough information, please add an output file to the Job Step (under Advanced).
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply