Online Documentation for SQL Backup for SQL Server

SQL Backup settings


This page contains set of specific backup options. You can make changes if needed.

 

Editing Service task template - Backup Database - Angel Options

 

 

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 best speed and '9' for best compression.

 

CheckBox Encryption

Enable the option to encrypt backup.

 

Encryption Password

Set and confirm password that is used for backup decryption.

 

Encryption Type

Select the encryption algorithm.