0 out of 1 rated this helpful - Rate this topic

Recovery Models and Transaction Log Management

SQL Server 2008 R2

Backup and restore operations occur within the context of a recovery model. A recovery model is a database property that controls how transactions are logged, whether the transaction log requires (and allows) backing up, and what kinds of restore operations are available.

In This Section

Recovery Model Overview: Introduces the three recovery models (simple, full, and bulk logged).
Choosing the Recovery Model for a Database: Discusses choosing a recovery model in terms of your recovery goals and requirements for a database, the database size and structure, and whether you are willing and able to manage log backups for the database.
Recovery Models for System Databases: Summarizes the recommendations for what recovery model to use with each of the system databases.
Operations That Can Be Minimally Logged: Identifies the set of operations that are fully logged under the full recovery model and are minimally logged under the bulk-logged recovery model.
Considerations for Switching from the Simple Recovery Model: Contains information about switching to and from the simple recovery model.
Considerations for Switching from the Full or Bulk-Logged Recovery Model: Contains information about switching between full and bulk-logged recovery and switching from full or bulk-logged to simple recovery.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD

Recovery Models and Transaction Log Management

Reference

Concepts

Other Resources

Community Additions