Topic :
- Manage
- Recovery Models
- Backup Architecture
- Backup Types
- Full Backups
- Differential Backups
- Transaction Log Backups
- Partial Backups
- File Backups
- Copy-Only Backups
- Backup Compression
- Logical Backup Devices
- The GUI Backup Interface
- Backups from T-SQL
- Using Encryption
- Backing Up the System Databases
- Backup History
- Summary
1. Recovery Model: “What Is a recovery Model”
Recovery Model is a database property that controls the transaction log maintenance. A recovery model controls how transactions are logged. The recovery Model is the context on which your backup and restore strategies are based on for a particular database.
There are three types of recovery models.
There are three types of recovery models.
1. FULL
2. BULK LOGGED
3. SIMPLE
FULL RECOVERY MODEL:
The full recovery model is the most suitable recovery model for a production environment
providing the highest level of data protection by logging all transactions. The full recovery model provides you the flexibility to chose any kind backup strategy by allowing you to perform any kind of backup available in the SQL Server.
3. SIMPLE
FULL RECOVERY MODEL:
The full recovery model is the most suitable recovery model for a production environment
providing the highest level of data protection by logging all transactions. The full recovery model provides you the flexibility to chose any kind backup strategy by allowing you to perform any kind of backup available in the SQL Server.
BULK LOGGING :
No comments:
Post a Comment