To create a SQL backup schedule

1        Select a SQL icon in the Navigation pane, and click Backup.

2        Select the Schedule Backup tab.

This retrieves a list of databases available for backup. If nothing displays, click the reload arrows at the bottom to refresh the list. If there is still nothing in the list, verify that the Agent prerequisites for Microsoft SQL are met.

3        Enter a unique Schedule Name.

4        If desired, enter a Schedule Description.

5        In the Databases to Protect area, check boxes to select the databases to backup in the schedule.

Databases that are offline cannot be selected for backup.

A database may exist in only one schedule at a time. Attempting to add a single database to multiple schedules results in failure to save the subsequent schedules.

Hover over the database name to see the database recovery model.

A separate backup is created for each database selected. Backups in the schedule execute simultaneously, up to the number of concurrent operations configured for the system.

6        If you would like to add new databases to this schedule automatically, check the Auto-include new Databases box.

This option can be enabled in only one schedule for each SQL server that the system is protecting.

If selected, a process is enabled that detects modifications to the list of available databases on the Microsoft SQL Server. Newly detected databases are added to the schedule automatically.

7        In the Schedule area, select a backup strategy from the list.

     Choose Full with Differentials, Full with Transaction Logs, or Custom.

     The schedule for the selected strategy displays below.

Important: Select a backup strategy appropriate for the recovery models of your databases. It may be necessary to create more than one backup schedule to account for different databases having different recovery models.

If you are using the full recovery model, be sure to use a customer schedule with a weekly transaction log backup. See Recommendations for full recovery model for more information.

8        Do one of the following:

For a non-custom strategy, define the frequency at which backups of each type will run using the fields below each backup.

For a custom strategy, click the Calendar icon to define the frequency at which backups of each type will run. Do the following for each backup instance:

     Drag a backup icon onto the calendar. Drag onto today’s date or later.

     In the Add Backup window, define the backup type, start date, start time, recurrence, and description (optional), then click Confirm.

9        If desired, modify the minimum and maximum retention and legal hold settings. These settings apply to all selected databases. To set different values for each database, do not enter settings here. Instead, finish creating your backup schedule, then go to Settings > Storage and Retention > Backup Retention. For details see About retention control.

10    Click Advanced Settings and specify optional settings as desired.

     Check the Verify Backup option to perform a data transfer integrity check for each backup.

     Select the backup device to which backups will be written.

     Uncheck the Email Schedule Report option if you do not want to receive information about this schedule in the daily system and schedule summary reports. This is checked by default.

     Uncheck the Email Failure Report option to disable sending an email notification upon failure of any backup job on the schedule. This is checked by default.

     Click Confirm to save Advanced Settings.

Note: Reports are delivered to email recipients specified in the report field in Settings > Clients, Networking, and Notifications > Email Recipients. The system and schedule summary reports are sent at 8 AM by default. To change the time of day the report is sent, see To modify the time that scheduled reports are generated.

11    Click Save to create the schedule.