You can select one of three recovery models for each database in Microsoft® SQL Server™ 2000 to determine how your data is backed up and what your exposure to data loss is. The following recovery models are available:
Simple Recovery allows the database to be recovered to the most recent backup.
Full Recovery allows the database to be recovered to the point of failure.
Bulk-Logged Recovery allows bulk-logged operations.
The recovery model of a new database is inherited from the model database when the new database is created.
Note The recovery model for a new database in SQL Server 2000 Personal Edition and SQL Server 2000 Desktop Engine defaults to Simple Recovery.