To execute a 1-time SQL backup

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

2        Select the 1-Time 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        In the Databases to Protect area, check boxes to select the databases to backup. Databases that are offline cannot be selected for backup.

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

4        Choose the type of backup by selecting Full, Differential, or Transaction.

If a restore operation was performed since the last backup, or if a full backup has not been performed for the selected database(s), be sure to select the Full backup option. If either condition is true and the Differential or Transaction Log backup option is chosen, the system will not queue the request.

5        Select an available device in the Available Devices area. By default, backups are stored on the default device.

6        If desired, check the Verify Backup box to perform a data transfer integrity check for each backup.

For SQL, inline verifies are done during the backup. This method decreases the amount of time required for verification. When the backup completes, the agent compares its checksum with the system’s checksum. If they differ, the backup fails.

7        Click Backup at the bottom of the screen to initiate the backup process.

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.

8        To view the status of the active backup operations, select Settings > System Monitoring > Jobs.

9        See Monitoring running backup jobs for details. To see the status of completed backup jobs, see Viewing backups.