Export (0) Print
Expand All
3 out of 11 rated this helpful - Rate this topic

Simple Recovery

SQL Server 2000

With the Simple Recovery model, the database can be recovered to the point of the last backup. However, you cannot restore the database to the point of failure or to a specific point in time. To do that, choose either the Full Recovery or Bulk-Logged Recovery model.

The backup strategy for simple recovery consists of:

  • Database backups.

  • Differential backups (optional).

Note  This model is similar to setting the trunc. log on chkpt. database option in Microsoft® SQL Server™ version 7.0 or earlier.

To recover in the event of media failure

  1. Restore the most recent full database backup.

  2. If differential backups exist, restore the most recent one.

Changes since the last database or differential backup are lost.

To create a database backup

Transact-SQL

Enterprise Manager

SQL-DMO

To restore a database backup

Transact-SQL

Enterprise Manager

SQL-DMO

To create a differential database backup

Transact-SQL

Enterprise Manager

SQL-DMO

To restore a differential database backup

Transact-SQL

Enterprise Manager

SQL-DMO

See Also

Selecting a Recovery Model

Full Recovery

Bulk-Logged Recovery

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.