Legacy SQL backup types and schedules

Based on the information provided in the previous screen, one or more backup types may have been pre-selected. For each of the selected backup types, click Modify Schedule to assign a backup frequency.

The available backup frequencies are:

Recurring: This option allows the specifications of database backups on an hourly basis. The number of hours between two backups can be set between a time interval indicated by the Start time and End time or it can be done starting at the Schedule time. The designated time is denoted on a 24 hour clock. Performing backups at an hourly rate immensely reduces the possibility of data loss.

For example, a schedule with a Start Time of 15:57, an End Time of 23:57, and a recurring value of 1 hour illustrate that the selected database backup will every hour between the times of 15:57 and 23:57.

Recurring frequencies can be assigned for full, differential, and transaction log backups.

     Daily – Establishes the backup to run once a day.

     Weekly – Establishes the backup to run once a week on a specific day.

     Monthly – Establishes the backup to run once a month on a specific date.

In general, a full backup should precede a differential and transaction log backup. Therefore, if differential backup type is selected, the SQL Server agent first confirms that a full backup was previously performed. If a full backup was not performed, the SQL Server Agent launches a full backup. If a full backup has already been performed, the SQL Server agent launches the requested differential backup.

The final step in creating or modifying the schedule is to save the profile. Newly created or modified profiles must be saved before they can be assigned to a database. If any changes are made to a profile after it has been assigned to a database, the profile must be removed and reassigned to the database in order for the changes to take effect.

When Save is clicked, the SQL Server agent saves the profile and enables the print functionality. Clicking Close returns to the main SQL Server agent interface.