SQL Database Error - BACKUP LOG cannot be performed because there is no current database backup
top of page

SQL Database Error - BACKUP LOG cannot be performed because there is no current database backup


Suppose you try to take a log backup of a SQL database, and it gives the error message - Msg 4214, Level 16, State 1, Line 1 BACKUP LOG cannot be performed because there is no current database backup.


SQL Database backup log error

You require a full backup for a new SQL Database in full recovery mode before taking any transaction log backup. You get the error message if you try to take a log backup for a new database without a full backup.

As shown below, after taking a full backup, log backup executes successfully.


Backup Database TestDB to disk='TestDB.bak'
go
Backup Log TestDB to disk='TestDB.trn'

Take full and log backup

51 views0 comments
bottom of page