Page History

...

• A list of databases you want to back up.
• A set of backup operations to be performed on those databases.
• A set of schedules according on which the backups will be performed.

You can choose to run the associated backup jobs on a specific schedule, to run them on demand (execute the jobs manually from the Management Console), or to define a policy for monitoring purposes only. You can then monitor the status of each backup policy from the Management Console.

...

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.

What constitutes a good backup strategy?

...

• The creation of regularly scheduled database backups.
• The creation of frequent differential backups between full backups.
• The creation of transaction log backups more frequently than differential backups.

Database backup creation depends on server activity and data sensitivity. Ensure you implement a strategy that allows you to create policies that back up both user databases and system databases.

...

• 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.
• Review details.
  
  

...