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
- Restore the most recent full database backup.
- If differential backups exist, restore the most recent one.
Changes since the last database or differential backup are lost.
To create a database backup
To restore a database backup
To create a differential database backup
To restore a differential database backup