Online Documentation for SQL Backup for SQL Server


At this page you can define backup options. This tab is only available for SQL Server provider selected. The following form is displayed for SQL Server 2008 and older versions.


Write type

RadioButton Append / RadioButton Overwrite

Select whether the media should be appended or overwritten during the backup operation. By appending another backup set to existing media, the previous contents of the media remain intact, and the new backup is written after the end of the last backup on the media.


Editing Service task template - Backup Database - Backup Options


Block size

Define the size of a data block. Possible values are: RadioButton Default, RadioButton To restore from CD (2 KB), RadioButton Other (i.e. you can specify an arbitrary value). The supported sizes are 512, 1024, 2048, 4096, 8192, 16384, 32768, and 65536 (64 KB) bytes. Possible values are: Default, To restore from CD (2 KB), Other (i.e. you can specify an arbitrary value).


Backup password

If necessary, you can set a Password for the backup: enter the password twice in the respective edit fields.


Backup encryption

You can set SQL Server encryption options for backups.


CheckBox Encrypt backup - enables backup encryption.

Select the encryption algorithm in Algorithm and the certificate or asymmetric key in Certificate or assymmetric key field. Please note that you can only use certificates protected by master key or EKM asymmetric keys from master database.

For servers that support backup encryption the following options are available:


Editing Service task template - Backup Database - Backup Options2014short


CheckBox Backup compression

This option enables backup compression overriding the server-level default (for SQL Server 2008 Enterprise and later versions).