Error message: The statement BACKUP LOG is not allowed while the recovery model is SIMPLE mode when backing up a Transaction Log file.
Error log may inlcude: Error 12300 or Error 12309
BACKUP LOG is terminating abnormally.
The statement BACKUP LOG is not allowed while the recovery model is SIMPLE. Use BACKUP DATABASE or change the recovery model using ALTER DATABASE.
Database file must be in FULL recovery mode to backup transaction logs.
1. In SQL Server Enterprise Manager, select Server/Instance | Database.
2. Right click and select Properties | Options | Recovery model.
3. Change the Recovery Model from Simple to Full.
NOTE: If you are not comfortable making these changes, please contact your System or Database Administrator.
For additional information refer to Microsoft Knowledge Base Article ID 303229 - "A transaction log backup job that is created in Database Maintenance Planner fails to execute":
