December 11, 2009 at 1:42 pm
Error message:
Date12/11/2009 3:28:09 PM
LogJob History (TransactionJobEveryHour.Subplan_1)
Step ID1
ServerMDSVSQL
Job NameTransactionJobEveryHour.Subplan_1
Step NameSubplan_1
Duration00:00:46
Sql Severity0
Sql Message ID0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0
Message
Executed as user: CUSTOMDIRECT\sqlservices. ...kage Utility Version 9.00.3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 3:28:09 PM Progress: 2009-12-11 15:28:52.65 Source: {63C7AFB5-3E87-4108-8E07-80A52217E4FF} Executing query "DECLARE @GUID UNIQUEIDENTIFIER EXECUTE msdb..sp".: 100% complete End Progress Progress: 2009-12-11 15:28:54.94 Source: Back Up Database (Transaction Log) Executing query "EXECUTE master.dbo.xp_create_subdir N'F:\Transacti".: 100% complete End Progress Error: 2009-12-11 15:28:55.05 Code: 0xC002F210 Source: Back Up Database (Transaction Log) Execute SQL Task Description: Executing the query "BACKUP LOG [Voice_Customer] TO DISK = N'F:\TransactionJobs\Voice_Customer\Voice_Customer_backup_200912111528.trn' WITH RETAINDAYS = 1, NOFORMAT, NOINIT, NAME = N'Voice_Customer_backup_20091211152854', SKIP, REWIND, NOUNLOAD, STATS = 10 " failed with the following error: "BACKUP LOG cannot. The step failed.
Why is this happening?
Anyone knows?
December 11, 2009 at 2:15 pm
Krasavita (12/11/2009)
failed with the following error: "BACKUP LOG cannot.
Do you see error information in the SQL Error Log, post it here, since the vital part of information (look at the quoted information) is not available in the error message posted.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 11, 2009 at 4:42 pm
Has the job worked in the past?
Is there adequate disk space on your F: drive?
Please check your error log for messages and post here as Bru requested.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 11, 2009 at 5:26 pm
DB in simple mode?
no full backup taken yet?
---------------------------------------------------------------------
December 11, 2009 at 5:34 pm
george sibbald (12/11/2009)
DB in simple mode?no full backup taken yet?
Those are good candidates for the cause.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 11, 2009 at 7:44 pm
job ran in past, I have spase and this id full mode
December 11, 2009 at 8:00 pm
What error information do you see in the SQL Server error log?
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 14, 2009 at 2:37 pm
Go to the Maintenance Plan folder, open the folder and find the maintenance plan. Right-click on that plan and select View History.
In that viewer - find the job that failed and click on the plus sign. From there, find the actual task that failed and review the error message for that task.
That should tell you why the task failed - and from there, we should be able to help you fix the problem.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 14, 2009 at 9:17 pm
The issue must have resolved itself
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 14, 2009 at 9:30 pm
CirquedeSQLeil (12/14/2009)
The issue must have resolved itself
I guess so.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply