Export (0) Print
Expand All

Using Recovery Models

SQL Server 2000

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft