Online Documentation for SQL Backup for SQL Server

Specifying backup options


At this step you can define backup options for source database(s).

 

Service tasks - Database Shipping - Specifying backup options

 

Backup folder

Specify the directory for backup. It is 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 this value can fasten backup speed. You are recommended to set one thread fewer than the number of processors.

 

CheckBox Compression

Enable the option to compress backup.

 

Compression Level

Defines backup file compression level. Use '1' for the best speed and '4' for the best compression.

 

CheckBox 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.

 

CheckBox Keep backups on the source server

Enable this option if you want to store backup files on the source server in the folder which is specified in the Backup folder field.