Setting SQL Server backup options

At this step you can define backup options. This step is available only on creating back up by means of SQL Server. The following dialog is displayed for SQL Server 2008 and older versions.

Block size

Define the size of a data block in bytes. 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).

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

Write type

Append / 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.

Backup compression

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

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

Backup encryption

You can set SQL Server encryption options for backups.

Encrypt backup - enables backup encryption.

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