Online Documentation for All SQLManager.net Products

Setting backup options


At this step you can define backup options. This step is available only on creating back up by means of SQL Server.

 

Service tasks - Backup Database - SQL Server backup - Setting backup options

 

 

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: RadioButton Default, RadioButton To restore from CD (2 KB), RadioButton 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.

 

CheckBox Backup compression

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