Table 1: SQL Server 2000 Recovery Models
SQL Server 2000 Recovery Model Common Incorrect Comparisons with Pre-SQL Server 2000 Database Options
Full Not the same as if neither database option SELECT INTO/Bulk Copy and Trunc. Log on Chkpt. is set. Some operations take longer when you use the Full model and require more log space than not setting either database option in earlier SQL Server releases.
Bulk_Logged Not the same as setting the SELECT INTO/Bulk Copy option. Although both settings provide similar performance, Bulk_Logged provides different recovery capabilities.
Simple Not exactly the same as setting both database options SELECT INTO/Bulk Copy and Trunc. Log on Chkpt. (although this recovery model provides the closest similarity in function to the earlier database-option settings).