MS SQL log backup failure
NovaBACKUP DataCenter
A reason for errors in MS-SQL log backup is the recovery model of the DB permits it to take log backups.
You may see this in the backup log in lines that begin with:
[Microsoft][ODBC SQL Server Driver][SQL Server]
The reason for the backup error (if it is located in SQL server) can be seen in this line.
Example message:
[Microsoft][ODBC SQL Server Driver][SQL Server]The statement BACKUP LOG is not allowed while the recovery model is SIMPLE. Use BACKUP DATABASE or change the recovery model using ALTER DATABASE.
Solution:
Remove the DB from log backup job unless you decide to change the recovery model of the database.