May 5, 2010 at 2:39 pm
Hi all,
I am doing a log backup and receiving that error code, any idea on how to solve this?
Thanks in advance
May 5, 2010 at 7:26 pm
What is the full error message? It is not showing up in the title.
I suspect, based upon a quick google search that your problem is because you don't have a full backup to start the log chain. This occurs when you break the log chain - and then you cannot perform any transaction log backups until you reestablish the log chain.
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
May 5, 2010 at 8:20 pm
The only reference to that error I saw on MSDN was here. It wasn't related to log backups.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 6, 2010 at 8:20 am
Hi All,
I did a Full Backup, then the log Backup, everything is good now,
Thanks
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply