MS SQL log backup failure

Last Updated: Apr 08, 2015 11:51AM CEST
MS SQL log backup failure
NovaBACKUP DataCenter
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.
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.
Remove the DB from log backup job unless you decide to change the recovery model of the database.
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
Invalid characters found