SQL Backup 5   

Creating Backups: Processing and Completion Settings

See Also
Creating Backups > Specify SQL Server > Select Backup Type and Database > File Settings > Processing and Completion Settings > Review Summary

This topic describes the wizard page for specifying the compression and encryption options for your backups, and for setting the completion options.

Backup processing

To compress the backup, select the Compress backup check box and select the compression level by moving the slider. Note that if SQL Backup Lite is installed on the SQL Server and you choose to compress your backup, compression level 1 is selected and you cannot change it. For more information about compression levels, see Compression Levels.

For full database backups, you can click Compression Analyzer to perform a test on the databases to check which compression level will produce the best result for your requirements. For more information about the Compression Analyzer, see Compression Analyzer.

 

To encrypt the backup, select the Encrypt backup check box, then type a password for the backup in Password, and again in Confirm password.

If SQL Backup Pro is installed on the SQL Server, you can choose 128-bit or 256-bit encryption; if SQL Backup Standard is installed on the SQL Server, you can choose only 128-bit encryption; if SQL Backup Lite is installed on the SQL Server, you cannot encrypt the backup. However, note that you can restore 128-bit and 256-bit encrypted backups using SQL Backup Pro, SQL Backup Standard, or SQL Backup Lite.

You must remember your password; if you do not, you will not be able to access the encrypted backup.

On completion

Select the Verify backup files check box if you want SQL Backup to run a verification of the backup files when they have been created. When the backup process completes, the results of the verification are displayed in the Activity History. They are also saved in the SQL Backup completion log file.

 

If you want to receive an email with a copy of the completion log, select the Send email notification check box, and enter the email address. This option is available only if you have entered your email settings. For more information about setting up email notification, see Email Notification Options.

To send the log to multiple email addresses, type each address separated with a semi-colon (;). For example:

dba01@myco.com;dba02@myco.com

If you want to receive an email only if an error occurs during the backup process, select Send on failure only.

If SQL Backup Lite is installed on the SQL Server, you cannot use email notification.

 

If you want a copy of the backup files to be created on a network share when the backup has completed, select the Copy backup to network check box, and then type the network share details in the box or click to use the file browser. For information about how to specify file names on remote servers, see Specifying File Paths.

The 'log on' user for the SQL Backup Agent on the source SQL Server must have permissions to create files on the network share. If it does not have the appropriate permissions, a warning is displayed in the Activity History when the backup has completed. For more information about using network shares with SQL Backup, see Using Network Shares with SQL Backup.

 

 

 


© Red Gate Software Ltd 2007. All Rights Reserved.