Error
[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.
Cause
Your SQL database(s) has been created as a simple database and doesn’t have a transaction log.
When the transaction backup runs, it fails because there is no log to backup. This is normal and not an issue.
Fix
When an SQL backup is created it creates a full and a transaction backup schedule.
To resolve this issue, remove the transaction backup schedule.
Very often these types of SQL databases are very small and can be backed up in full each day.
