|Table 1: SQL Server 2000 Recovery Models |
|SQL Server 2000 Recovery Model
||Common Incorrect Comparisons with Pre-SQL Server 2000 Database Options
||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.
||Not the same as setting the SELECT INTO/Bulk Copy option. Although both settings provide similar performance, Bulk_Logged provides different recovery capabilities.
||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).