Before you begin backing up a SQL Server database, you need to know which recovery model the database is using. There are three different recovery models: FULL, BULK_LOGGED, and SIMPLE.

If you put your databases in Simple Recovery Model, it tells the SQL Server CHECKPOINT process to write the transactions from the T-log to the data file and after a successful write, to purge them ...

Well, the official “Deprecated Database Engine Features in SQL Server 2005” document first of all, refers to a replacement of “None”. ... switch to the simple recovery model”.