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

Recovery Models and Transaction Log Management

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.

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?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.