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 (MSDE 2000) defaults to Simple Recovery.