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?
...