August 23, 2010 at 8:08 am
Hello all,
I have SQL 2008 and Im having problems with the Transaction Logs backups. Im using the Maitenance Plan in the Management Studio to run the backups. Im getting the following error whenever my Transaction Log backup runs:
"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.
I have set to where it should backup to another drive on the server. The ".bak" file shows in the drive but I get the error in the Management Studio. There is also a current database backup that runs with no errors hours before the Transaction Log job begins to run. Can someone please help me out and tell me what I am doing wrong. I appriciate any help that I can get.
August 23, 2010 at 8:16 am
If you take a full backup immediately before running the log backup job, does it still fail? It's possible that someone is running a BACKUP LOG WITH TRUNCATE_ONLY or similar between your full backup and your transaction log backup.
John
August 23, 2010 at 8:16 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic973456-391-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply