SQL SERVER – FIX : ERROR : 4214 BACKUP LOG cannot be performed because there is no current database backup

March 27, 2010

Pinal Dave

SQL

I recently got following email from one of the readers. It is about Backup Log file.

Hi Pinal,

Even thought my database is in full recovery mode when I try to take log backup I am getting following error.

BACKUP LOG cannot be performed because there is no current database backup. (Microsoft.SqlServer.Smo)

How to fix it?

Thanks,
[Name and email removed as requested]

Solution / Fix:

This error can happen when you have never taken a full backup of your database and you try to attempt to take backup of the log only. Take full backup once and attempt to take log backup. If the name of your database MyTestDB follows procedure as following.

BACKUP DATABASE [MyTestDB]
TO DISK = N'C:\MyTestDB.bak'
GO
BACKUP LOG [MyTestDB]
TO DISK = N'C:\MyTestDB.bak'
GO

SQL SERVER - FIX : ERROR : 4214 BACKUP LOG cannot be performed because there is no current database backup backuplog-800x600

Please note that this is a very common issue which we see when a user have just changed their recovery model from Simple Recovery Model to Full Recovery Model. It is recommended to take full backup whenever you change your recovery model to avoid any unpleasant situation. Remember, it is important that your backup can be restored in your system so always try to restore your backup on your development server.

Please leave a comment with your opinion.

Reference: Pinal Dave (https://blog.sqlauthority.com)

SQL Backup, SQL Error Messages, SQL Log, SQL Restore, SQL Scripts, SQL Server

SQL SERVER – Generate Report for Index Physical Statistics – SSMS

SQLAuthority News – MS Access Database is the Way to Go – April 1st Humor

Interview Question of the Week #049 – Taking Database Offline

December 13, 2015

SQL SERVER – What is Tail-Log Backups?

March 7, 2018

SQL SERVER – OVER clause with FIRST _VALUE and LAST_VALUE – Analytic Functions Introduced in SQL Server 2012 – ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING

November 10, 2011

24 Comments. Leave new

mark
June 24, 2018 9:48 am
Hi, Pinal
Thank you very much !
Your information always help me a lot!
Reply
Albert van Biljon
February 12, 2020 4:55 pm
We sometimes get this error on our production environment – most of the time we do NOT get the error. The database backup is done by Maintenance Plan which backs up all of the databases on the server; One of the first steps is to backup all the databases and a subsequent step is to backup the logs.
The error in the log file is:
Failed:(-1073548784) Executing the query “BACKUP LOG [DBNAME] TO DISK = N’\\stor-syn…” 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.
The database should always be in Full Recovery mode, but I don’t know how to check whether it is being changed by another process, although I doubt that.
Any ideas how to investigate this further?
Reply