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.
 
Solution:
Remove the DB from log backup job unless you decide to change the recovery model of the database.
http://assets2.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete