Msg 4208, Level 16, State 1, Server servername\databasename, The statement BACKUP LOG is not allowed while the recovery model is SIMPLE. Use BACKUP DATABASE or change the recovery model using ALTER DATABASE.

To resolve this error and successfully configure backups for MSSQL databases with the Simple recovery model, please follow these recommended steps:

1. Utilize backup strategies with the MSSQL server plugin in BDRSuite Backup Server and BDRSuite Clients.

2. Note that 'TRANSACTIONAL' log backups are not supported for databases using the Simple recovery model. To address this issue:

a) Edit the backup schedule and uncheck/remove the T-Log backup schedules for the affected database.

b) Alternatively, create a new Backup Job specifically for this database, excluding 'TRANSACTIONAL' log backups.

3. Implement the following backup strategies:

a) For the 'Master' database, configure a separate backup job with a 'FULL' backup schedule only. 'DIFFERENTIAL' and 'TRANSACTIONAL' log backups cannot be performed on the master database. Additionally, restoring the 'master' database is necessary as the first step in SQL Server disaster recovery.

b) Databases using the 'Recovery Model' as 'Simple' should be set up with 'FULL' backup types and optionally 'DIFFERENTIAL Log' backup types, as 'TRANSACTIONAL' log backups are not supported.

c) For databases using 'Recovery Model' as 'Full' or 'Bulk Logged,' configure 'FULL' backup types and optionally include 'DIFFERENTIAL' and 'TRANSACTIONAL LOG' backups.