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] ...
Run a backup from System Tray icon – SAFE Backup
Open System tray and find the SAFE Backup icon (you will likely have more icons in here): Right click on this, go to “Backup” and select the set name on this machine you wish to start. The icon will start to flash while the backup is running.
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 ...
Restarting Synology Backup Scheduler - SAFE Backup
If a backup is missing the schedule and runs directly on a Synology, you can give the scheduler a restart by following these steps while logged into the NAS. STEP 1 - Open PowerShell Press Windows key + X and select Terminal or PowerShell STEP 2 - ...
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 ...