Online Documentation for SQL Administrator for SQL Server

Setting backup encryption options


Use this step to set backup data encryption parameters.

This step appears only when performing backup on SQL Server 2014 and is available for editing only if the !RadioButton Back up to a new backup media option was selected on the Backup Media Options step.

 

Backup Database Wizard - Setting backup encryption

 

 

 

!CheckBox Encryption

Check this option to enable the data encryption while creating a backup.

To encrypt during backup, you must specify an encryption algorithm, and an encryptor to secure the encryption key.

 

Algorithm

Select one of the encryption algorithms for a backup:

!RadioButton AES-128

!RadioButton AES-192

!RadioButton AES-256

!RadioButton Triple DES

 

Encryptor

If you choose to encrypt you also have to specify the encryptor. Encryptors can be a master key certificate or an Extended Key Management asymmetric key from the master database. All available encryptors are listed in the combobox.