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.

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”.

SQL Server 2005 databases are set to the Full recovery model by default, so you may need to start creating log backups even if you haven’t ran into problems yet.