MS SQL log backup failure
Last Updated: Aug 28, 2013 10:31AM PDT
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.
[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.
Remove the DB from log backup job unless you decide to change the recovery model of the database.