CloudBerry Lab
            Knowledge Base Cloudberry Lab General Backup software

            Backup for Windows - MS SQL - Recovery model SIMPLE is invalid for operation

            The error in the logs and software interface is as follows:
            ERROR - Error on database backup msdb starting. Type: Log. Compression: False. Verify: False. CopyOnly: False
            CloudBerryLab.Backup.MSSQL.Exceptions.InvalidRecoveryModelException
            Recovery model SIMPLE is invalid for operation

            So here is the explanation.
            The reason for the issue is that transaction log backups can't be performed for databases with SIMPLE recovery model. We generate a message that indicates that a particular database has SIMPLE recovery model.

            SQL databases in SIMPLE model are not available for transaction log backup. Do not check that option and the backup would be successful. To perform full sequence of SQL backup please set your base to recovery model FULL.

            You can modify the recovery model in Microsoft SQL Server Management Studio: connect to SQL Server, right click on a database, select Properties, Options.


            For more information about SQL server recovery models, please see the following article:
            Updated: 24 Oct 2017 12:34 AM
            Helpful?  
            Help us to make this article better
            0 0