Online Documentation for SQL Backup for SQL Server


This page is used to define backup options for database shipping step.


Editing Service task template - Database Shipping - Backup



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.


CheckBox Compression

Enable the option to compress backup.


Compression Level

Defines backup file compression level. Use '1' for best speed and '4' for 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 specified in the Backup folder field.