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

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

I recently got the below error.

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?

Solution / Fix:

This error can happen when you have never taken 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 back up. If the name of your database is MyTestDB follow procedure as following.

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