Thursday, February 7, 2013

Msg 4214 : BACKUP LOG cannot be performed because there is no current database backup


Recently I was trying to do a backup operation for one of my Sharepoint database log files and I got the above error message

BACKUP LOG [DB-100] TO DISK='E:\BACKUPTEST\TESTBACKUPlog.bak'
GO

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.

How to fix this:

This error comes up when you you have never taken full backup of your database and you do the backup of the log only. Take full backup once and then try to take log backup. If the name of your database is DB-100 follow procedure as following.

BACKUP DATABASE [DB-100] TO DISK='E:\BACKUPTEST\TESTBACKUPdb.bak'
GO

BACKUP LOG [DB-100] TO DISK='E:\BACKUPTEST\TESTBACKUPlog.bak'
GO