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?
...
Backup policies allow you to plan and schedule your SQL Server backup maintenance, as well as monitor its success and failures, all from a single point of contact at the Management Console. By allowing the application and scheduling of a set of backup operations across all of your SQL Server instances enterprise-wide, SQL Safe policies make updating your maintenance plans a quick and easy process.
Scroll pdf ignore |
---|
SQL Safe is a high-performance backup and recovery solution for your SQL Servers. Learn more > > |