Error 4208

Troubleshooting SQL Server

Troubleshooting

Error 4208

Severity Level 16
Message Text

The statement %hs is not allowed while the recovery model is SIMPLE. Use BACKUP DATABASE or change the recovery model using ALTER DATABASE.

Explanation

When using the Simple Recovery model, the log is truncated when periodic checkpoints occur. Only full database and differential database backups are allowed because the log has been truncated and any log backups made would be unusable.

Action

To maintain your database by performing only full and differential database backups, keep using the Simple Recovery model along with BACKUP DATABASE.

To maintain a full set of transaction log backups to guarantee that no change to the database is lost in the event of a failure,  use ALTER DATABASE to change the recovery model to full or bulk-logged. Then use BACKUP DATABASE, and begin taking periodic transaction log backups using BACKUP LOG.

See Also

BACKUP

Setting Database Options

sp_dboption

Troubleshooting Backing Up and Restoring