The recovery mode for SQL Server databases need to be in FULL mode. SIMPLE mode is not compatible.
OS: Windows (ALL)
Backup Set Type: MS SQL Server Backup
Backup Manager version: 5.X.X.X
When performing a MS SQL transaction log backup, the following error message is received in the backup report:
The message suggests that recovery model of the database in concern is currently set to SIMPLE. When using the simple recovery model, the log is truncated when periodic checkpoints occur. Only full database and differential database backups are allowed.
The following table summarizes the recovery models and backup types available with each recovery model:
|Recovery Model / Backup||Complete||Differential||Transaction Log|
To resolve the issue, please modify the recovery model of the database in concern to FULL.
For OBM version prior to 5.5.X.X:
.f you are using OBM version prior to 5.5.X.X, please open Enterprise Manager or SQL Server Management Studio (depending on the MS SQL version in concern), right click on the database name, select Properties, select the Options tab and select recovery model from the drop-down list.
Example with MS SQL 2000:
Example with MS SQL 2005:
If you are using MSDE, please issue the following commands:
>osql -E -S [Server Name] -Q "ALTER DATABASE [Database Name] SET RECOVERY FULL"
This will enable transaction logging option for the MSDE databases and allow transaction log backup to be performed.
For OBM version 5.5.X.X or later:
If you are using OBM version 5.5.X.X or later, you can simply modify the recovery mode of your database by right clicking on the corresponding database in the Backup Source menu of OBM, and then select Recovery Model: