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.
These are the things I have tried:
I looked at the history of the job and it has been failing since Friday.
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.
Has anyone ever faced this error before? And if so, what was your way to resolve this? Any pointers would be much appreciated.