Online Documentation for SQL Backup for SQL Server
General
This page is used to define backup options for database shipping step.
Backup folder
Specify the directory for backup. It must be set relatively the source server. You can check availability of this folder by clicking the corresponding button.
Max Thread Count
Indicates the number of threads to be used for backup operation. Increase the number of threads for faster speed. If you are using a multi-processor system, increasing of this value can fasten backup speed. You are recommended to set one thread fewer than the number of processors.
Compression
Enable the option to compress backup.
Compression Level
Defines backup file compression level. Use '1' for best speed and '4' for best compression.
Encryption
Enable the option to encrypt backup.
Encryption Password
Set password that is used for backup encryption.
Confirm password
Confirm the password specified as an encryption password above.
Encryption Type
Select the encryption algorithm.
Keep backups on the source server
Enable this option if you want to store backup files on the source server in the folder specified in the Backup folder field.