Using Recovery Models

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

  Simple Recovery allows the database to be recovered to the most recent backup.

• Full Recovery

  Full Recovery allows the database to be recovered to the point of failure.

• Bulk-Logged Recovery

  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.