Scheduling Backups: Processing and Encryption Settings

Scheduling Backups > Specify SQL Server > Select Backup Type and Database > Create Backup Schedules > File Settings > Processing and Encryption Settings > Review Summary

This topic describes the wizard page for specifying the compression and encryption options for your backups. You can also set options for optimizing the backup process on this page.

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 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 or SQL Backup Lite.

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

Optimization

SQL Backup provides some settings for optimizing your backup jobs.

If you are backing up to a Single file or Single backup file, mirrored to second location, SQL Backup can use multiple threads to create the backups. This can speed up the backup process. Select the Use multiple threads check box, and type or select the number of threads up to a maximum of 32. For more information about using multiple threads, see Optimizing Backup Speed.

Maximum transfer size specifies the maximum size of each block of memory to be used when SQL Backup stores backup data. The default value is 1024 KB; you may want to change this value if a SQL Server reports that it has insufficient memory to service requests from SQL Backup.

Maximum data block specifies the maximum size of data blocks to be used when SQL Backup stores backup data. The default value is 4096 KB.

Note that if you want to specify the network transfer packet size, change the connection properties for the SQL Server.