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.