Blog Post

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

Original post (opens in new tab)

Rate

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

Share

Share

Rate

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating