Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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
| Topic | Description |
|---|---|
Introduces the three recovery models (simple, full, and bulk logged). |
|
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. |
|
Summarizes the recommendations for what recovery model to use with each of the system databases. |
|
Identifies the set of operations that are fully logged under the full recovery model and are minimally logged under the bulk-logged 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. |
See Also
Concepts
Choosing the Recovery Model for a Database
Recovery Models for System Databases
Considerations for Switching from the Full or Bulk-Logged Recovery Model
Considerations for Switching from the Simple Recovery Model
Transaction Log Truncation
Transaction Log Physical Architecture
Other Resources
ALTER DATABASE (Transact-SQL)
Backing Up and Restoring Databases in SQL Server