Page History
...
Implementing a policy requires that you have a clear understanding of your backup strategy. To determine a backup strategy to use, consider the following recovery model requirements.
Model | Full Backup? | Differential Backup? | Transaction Log Backup? | File or Filegroup Backup? |
|---|---|---|---|---|
| Simple Model | Required | Optional | N/A | N/A |
| Full Model | Required | Optional | Required | Optional |
| Bulk-Logged Model | Required | Optional | Required | Optional |
What constitutes a good backup strategy?
...
- Name the policy
- Select the databases you want to back up
- Select backup options
- Specify where you want to store the backup files
- Schedule when and how often you want the backup to occur
- Get email notifications about the policy status
...