Click here to Skip to main content
15,867,330 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
We have a log backup job running every hour. The log backups are being taken for all the databases except one of them. For security purposes lets call this database FAILED_DB.I looked at the history of the job and it has been failing since Friday.


What I have tried:

These are the things I have tried:

In the job history, it states that 'Executed as user: ...tabase backup. [SQLSTATE 42000] (Error 4214) BACKUP LOG is terminating abnormally. [SQLSTATE 42000] (Error 3013). However, FAILED_DB is set to Full recovery model & there has been a full backup taken last night.


In the SQL Server logs, it states ''BACKUP failed to complete the command BACKUP LOG FAILED_DB. Check the backup application log for detailed messages.'

I also checked the Event Viewer, and it still states to check the backup application log for detailed message.
Posted
Updated 21-Dec-20 6:30am

1 solution

I think it's saying you need a full backup (first) in order to run the type of backup you are doing now. "Something" happened previously (or did not happen) that precipitated this.

SQL SERVER - Fix - Error: 4214: BACKUP LOG cannot be performed because there is no current database backup. - SQL Authority with Pinal Dave[^]
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900