Using Recovery Models

Administering SQL Server

Administering SQL Server

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.