April 25, 2010 at 11:03 am
I know on which db is failing but error logs are not telling me explanation.What do I need to do to fix my transaction job not to fail (reason why).Can someone please help me. This job was ok , but today is failing every hour Thank you
April 25, 2010 at 11:27 am
How do you know it is failing? You state there are no errors, where have you looked?
Is this a maintenance plan job? If so, View History for the maintenance plan - find the task that is failing. At the bottom, there is a message box with all of the information about the task - copy/paste that into notepad to see what error it is generating.
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
April 25, 2010 at 1:33 pm
Operator Paged
Retries Attempted0
Message
Executed as user: \sqlservices. ...042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 3:00:00 PM Progress: 2010-04-25 15:00:04.16 Source: {63C7AFB5-3E87-4108-8E07-80A52217E4FF} Executing query "DECLARE @GUID UNIQUEIDENTIFIER EXECUTE msdb..sp".: 100% complete End Progress Progress: 2010-04-25 15:00:06.52 Source: Maintenance Cleanup Task Executing query "EXECUTE master.dbo.xp_delete_file 0,N'F:\Transacti".: 100% complete End Progress Progress: 2010-04-25 15:00:07.83 Source: Back Up Database (Transaction Log) Executing query "EXECUTE master.dbo.xp_create_subdir N'F:\Transacti".: 100% complete End Progress Progress: 2010-04-25 15:00:07.85 Source: Back Up Database (Transaction Log) Executing query "EXECUTE master.dbo.xp_create_subdir N'F:\Transacti".: 100% complete End Progress Progress: 2010-04-25 15:00:07.85 Source: Back Up Database (Transaction Log) ... The package execution fa... The step failed.
April 25, 2010 at 1:39 pm
Here is errror:
Executing the query "BACKUP LOG [Jul_reports] TO DISK = N'F:\\TransactionJobs\\Jul_Reports\\jul_Reports_backup_201004251500.trn' WITH RETAINDAYS = 1, NOFORMAT, NOINIT, NAME = N'Jul_Reports_backup_20100425150007', SKIP, REWIND, NOUNLOAD, STATS = 10
" failed with the following error: "BACKUP LOG cannot be performed because there is no current database backup.
BACKUP LOG is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Everything was ok until 2 a.m and then strt failing
April 25, 2010 at 1:46 pm
Krasavita (4/25/2010)
Here is errror:Executing the query "BACKUP LOG [Jul_reports] TO DISK = N'F:\\TransactionJobs\\Jul_Reports\\jul_Reports_backup_201004251500.trn' WITH RETAINDAYS = 1, NOFORMAT, NOINIT, NAME = N'Jul_Reports_backup_20100425150007', SKIP, REWIND, NOUNLOAD, STATS = 10
" failed with the following error: "BACKUP LOG cannot be performed because there is no current database backup. BACKUP LOG is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Everything was ok until 2 a.m and then strt failing
The error is right there in the message - someone has run a process that has broken the log chain. Probably ran the command BACKUP LOG [Jul_Reports] WITH TRUNCATE_ONLY, or the database was switched to SIMPLE recovery and then back to FULL.
Once the log chain is broken, you cannot perform transaction log backups until the log chain has been re-established. To do that, you need to perform either a full or diff backup on that database.
If you don't need the database in full recovery, switch to simple and stop performing transaction log backups.
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
April 25, 2010 at 2:13 pm
How can I check who ran the back up?
April 25, 2010 at 2:20 pm
I would check all scheduled jobs, and any scheduled jobs that ran right before this issue happened. I would also check the SQL Server logs to see if the backup command was run - or the recovery model was changed.
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
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply