BE2012: Backing up SQL Databases | Full / Simple Recovery Mode Issue
When performing a SQL Full backup using the 'Full Recovery Model' the backup succeeds but with exceptions as indicated in the following job completion message; "V-79-40960-37914 - Database database_name is configured to maintain transaction logs. Transaction log backups are not being performed. This will result in the log growing to fill all available disk space. Regular log backups should be scheduled or the database should be changed to the simple recovery mode."
Now when changing the Recovery Mode of the database from Full to Simple as required above using SQL Management Studio and then when performing subsequent Incremental backups the following job completion message appears: "V-79-57344-33960 - A log backup was attempted on database database_name that is not configured to support log backups. To change the configuration, use the SQL administration tools to set the recovery mode to Full. A new full backup should be performed if this setting is changed before a log backup is run."
Essentially what these two errors are saying is, "Use Simple Recovery, no wait, use Full Backup, no wait, use Simple Recovery, no wait, use Full Backup", and it can't decide which.
The error's contradict themselves, does anybody know how to tackle this issue?