Scenario:
The above error occurs while configuring MSSQL backups with the Simple recovery model type.
Solution:
To resolve this issue, we recommend you to follow backup strategies with MSSQL server plugin in Vembu NetworkBackup & OnlineBackup clients.
The 'TRANSACTIONAL' log backups cannot be done for simple recovery type databases as it is not supported. Hence to resolve this issue please edit the backup schedule and uncheck/remove the T-Log backup schedules or create a New Backup Job for this particular database alone.
We also would recommend you with the following backup strategies:
a) Configure a separate backup job for 'Master' database with 'FULL' backup schedule alone, as 'DIFFERENTIAL and TRANSACTIONAL' log backups cannot be done on the master database. And also 'master' has to be restored first when restoring SQL Server for disaster recovery.
b) The databases with 'Recovery Model' as 'Simple' should be configured with 'FULL' backup type and optionally with 'DIFFERENTIAL Log' backup types as 'TRANSACTIONAL' log backups cannot be done.
c) The databases with 'Recovery Model' as 'Full' or 'Bulk Logged' should be configured with 'FULL' backup type and optionally with 'DIFFERENTIAL' and 'TRANSACTIONAL LOG' backup.
Refer the Link below:
