SQL SERVER – Fix : Error Msg 4214 – Error Msg 3013 – BACKUP LOG cannot be performed because there is no current database backup

This is very interesting error as I could not found any documentation on-line. It took me nearly 1 hour to figure out what was creating error.

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.

Reason :
This error happened when we were truncating the logs before we take backup of the database.

Fix/Workaround/Solution :
Do not truncate log if differential backup is set up. Truncating log before backup brakes continuity of the log and creates issues when they are to be restored. Disrupted continuity creates not useful back up. This errors warns user when backup are becoming worthless.

Transactional backup truncates the log itself so there is no need to truncate log to keep it maintained.

Reference : Pinal Dave (http://blog.SQLAuthority.com)

About these ads

3 thoughts on “SQL SERVER – Fix : Error Msg 4214 – Error Msg 3013 – BACKUP LOG cannot be performed because there is no current database backup

  1. I am having the problem described above. I have not truncated logs, but I am still having this problem. There are multiple databases on the same server, only one of them is having this issue.

    Since I am not truncating logs, how can I fix this?

  2. It may be because u have been taken the backup (full) in simple recovery model, than u changed it to full revery mode, and took the Trn log backup…..

    if u have changed the recovery model from simple to Full than first u have to take full or differential backup…than u have to take trn log backup….

    Best

    Virendar Singh

  3. RE the statement: “Transactional backup truncates the log itself so there is no need to truncate log to keep it maintained.”

    Can you elaborate on this or point to some reference that explains how to keep a log file maintained at minimum size with DBA tools and practices, and in a manner that takes advantage of enterprise backup tools?

    We have both SS2200 and 2005 running on several servers, two clusters, and dozens of large databases that for some reason generate large t-logs (50 – 100 GB per server). It has become a very frequent occurrence that the log storage devices, SAN disks, become full. Now, we have Legato (for SS2000) and Microsoft DPM (for SS2005) running to do a full back up of all databases every night. So if I am to “maintain” these large log files, I don’t want to attempt to backup the databases to disk, that would be redundant and consume the very space I’m trying to free up.

    Is there a sensible way to “maintain” log files that grow to large sizes? BTW some of these log files belong to databases such as Changepoint and MOM, i.e. Microsoft products…

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s