Home > Troubleshooting > SAFE Backup > How to Fix a Simple Mode Error with SQL Backup

How to Fix a Simple Mode Error with SQL Backup

If you are backing up SQL databases and transaction logs at the same times, you may see the following 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." 

This error occurs because the transaction logs are in use due to the database being backed up. The database covers the logs as well, so the fix for this is to remove the transaction log backup and modify the database backup to be daily. 

Firstly, delete the log backup.

Next, modify the database backup to run daily.

When the scheduled backup next runs, you should no longer see the Simple Mode error.