How to Fix a Simple Mode Error with SQL Backup - SAFE Backup

How to Fix a Simple Mode Error with SQL Backup - SAFE 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, login to the backup client, or access the account on the web portal. Navigate to schedule for this set and delete the "Transaction Log" schedule. Modify, or create a, "database" backup schedule (type to "full") and set this to run daily.

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

    • Related Articles

    • Error: failed to initialize RemoteBDB.Cloud - SAFE Backup

      You may receive an error on your backup report for the following, or similar: Failed to initialize RemoteBDB.Cloud. Error=[BlockDBConfig.readConfig] unknown default path for creating new journal file config: 0 , caused by [RuntimeException] ...

    • Troubleshooting VSS errors – SAFE Backup

      Disclaimer: VSS is an OS component, the steps mentioned below should only be performed by your system admin and/or after consulting Microsoft. We cannot take responsibility for faults caused by following the below steps. VSS error codes and their ...

    • Can't login to Backup Server! - SAFE Backup

      If you try to login to the Backup Client and get this error message: Can’t connect to Backup Server! (java.net.ConnectException: Connection timed out: connect) It my be a network issue client side (for example if they have changed their DNS) please ...

    • View the debug.log files – SAFE Backup

      You will only really need to view this in the case of a missed backup, as this log will tell you when the next backup will run. To view the scheduler log, open file explorer and go to the C drive, open Users and select the user account that the ...

    • Stop a running backup – SAFE Backup

      If a backup is running and you want to stop it, open system tray and you will see the SAFE Backup icon, it will be spinning if the backup is running. Right click on this and go to “Stop Running Backup” – you will then need to select the set name that ...