The simple recovery model is the easiest to administer, but it is the option that has the greatest possibility for data loss. In this mode, your transaction log is truncated automatically based on a checkpoint in the database. These checkpoints happen often, and they cause the data in the transaction log to be truncated frequently.
Prior to SQL Server 2000, the
trunc. log on checkpoint database option was used to truncate the log on a checkpoint and produce the same type of behavior as simple recovery. This database option and the equivalent backup options
TRUNCATE_ONLY are no longer supported. The only supported method for truncating the transaction log in SQL Server 2012 is to switch the database to use the ...