Use this dialog box to specify tunable settings and log consistency checking for SQL backups.
Block Size
Specifies the block size that will be used during backup. The default block size for write operation is 65,536 bytes (or 64 KB). To increase the block size, enter any value from 512 bytes to 65,536 bytes.
Buffer Count
Specifies the total number of buffers that will be used to receive data from SQL Server during backup. The default value of buffer count is 20. To increase the buffer count, enter any value from 1 to INT_MAX, where INT_MAX is the maximum value of an INT on the platform being used.
Note: Buffer count should be equal or greater than the number of streams.
Maximum Transfer Size
Maximum transfer size is the maximum amount of data transferred at a time during a backup operation. The default value is 2,097,152 bytes (or 2048 KB). You can enter any value from 65,536 bytes (or 64 KB) to 4,194,304 bytes (or 4 MB). All data is transferred in multiples of 64 KB.
For more information, see Enhancing SQL Backup Performance.
Disable Log Consistency Check
By default, the Commvault software will check for log consistency during backup. If you leave this check box unselected and the Commvault software detects broken backup chain, the backup job will not proceed. If this check box is selected and the Commvault software detects broken backup chain, the backup job will not fail but the database being backed up might not be restored later on.