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

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]

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

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)

, , , , ,
Previous Post
SQL SERVER – Generate Report for Index Physical Statistics – SSMS
Next Post
SQLAuthority News – MS Access Database is the Way to Go – April 1st Humor

Related Posts

24 Comments. Leave new

  • 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

Leave a Reply

Menu