[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.
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.
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.