The Schedules tab of the SQL Safe Backup Policy Wizard allows you to schedule the frequency and duration of your backup operations. For each backup type, enter the appropriate information into each of the schedule fields to satisfy your backup requirements.
What information is on the Schedules tab?
For each operation you have included in the policy, you can specify when your operation will begin, how frequently backup jobs will be executed, and the respective duration for these operations. You can also choose to run the operation "On Demand," allowing you to easily manually execute the associated jobs according to your preset options.
How do you know what frequency to set?
The schedule of your operations should be determined by how much data you can afford to lose in the event of a catastrophic failure. The schedule should be developed in concert with your backup strategy. For example, for lab or development instances, you may want to schedule on-demand or weekly backups whereas for critical production instances you may want to schedule full backups every day with transaction log backups every hour.
Can you set a different schedule for each backup operation?
Each backup operation can have a different schedule. For instance, perhaps you decide you want to run full backups monthly, differential backups once a week, and transaction logs during business hours every day.
How do you set the schedule?
You can set up a schedule by defining the following options:
Field | Description |
|---|---|
Occurs | Unit of Frequency:
|
Daily Frequency | Time of day:
|
Duration | Length of time:
|
When an operation does not occur as scheduled, the backup policy will consider it "missed" and SQL Safe can notify you about it if you configured it to do so.
Once you configure the schedule of your backup operations, click NEXT to configure notifications.