Monday, November 9, 2009

Error 4214 or 3013 BACKUP LOG Cannot Be Performed Because There Is No Current Database Backup

The below error happened when we were truncating the logs before we take backup of the database. 

Msg 4214, Level 16, State 1, Line 1
BACKUP LOG cannot be performed because there is no current database backup. 

Msg 3013, Level 16, State 1, Line 1
BACKUP LOG is terminating abnormally. 

Fix / Solution :
Do not truncate log if differential or Transactional Log backup is set up. 
Truncating log before backup it will brakes the continuity of the log and creates an issues when they are to be restored.
transactional log error. log truncation while mirroring. Can we can truncate log while mirroring configured. can we truncate log while log shipping configured. backup failure. transactional log backup failure. how to resolve error 4214. 4214 error. sql server 2012 backup error. sql server 2008 r2 error. error while taking transactional log. log error.


Post a Comment