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

Working with SQL Server you face a  lot of different error messages. Some of them can be solved in a minute, another required more time. In this blog post, we are going to talk about error message like “BACKUP LOG cannot be performed because there is no current database backup.” Here is a full error message:

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.

Or, if you are using SQL Server Management to backup your database you will receive the following message:

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

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

It has to be admitted that you can get this error message when your database run under the simple, full or bulk-logged recovery models.

So, the reason that you receive this error message is that you have never performed a full backup of your database. In spite, this you are trying to backup the log only. That means that all you need to do is to perform a full backup of your database. You can do it using the following T-SQL Commands:

BACKUP DATABASE Adventureworks
TO DISK = 'D:\Adventureworks.bak'
GO
BACKUP LOG Adventureworks
TO DISK = 'D:\Adventureworks.bak'
GO

Also, you can  perform database backup using SQL Server Management Studio (SSMS): right-click on the database you need to backup, select “Tasks”, and then “Back up…”. Choose “Full” backup type, then specify a backup destination place and click “OK”.

Pass the same step to make a transaction log backup, but select “Transaction Log” instead of “Full” in the “Backup type” field.

To avoid this error we recommend you to use SQLBackupAndFTP to make SQL Server database backups automatically. With the help of SQLBackupAndFTP, you can backup your database according to your schedule and all backups will be sent to the selected destination place.

[Total: 14    Average: 4.1/5]

Leave a Reply

Your email address will not be published.