Configuring BUFFERCOUNT and MAXTRANSFERSIZE

Pixelated_1

Is it possible to configure the BUFFERCOUNT and MAXTRANSFERSIZE parameters when using Red Gate Backup Pro 7.60.26 and 7?

I see that values for both parameters are passed in as default when a backup command is generated.

BACKUP DATABASE DBName
TO VIRTUAL_DEVICE = 'SQLBACKUP_4CB6300E-6B3A-453B-BA93-50E691F7DF2B'
, VIRTUAL_DEVICE = 'SQLBACKUP_4CB6300E-6B3A-453B-BA93-50E691F7DF2B01'
, VIRTUAL_DEVICE = 'SQLBACKUP_4CB6300E-6B3A-453B-BA93-50E691F7DF2B02'
, VIRTUAL_DEVICE = 'SQLBACKUP_4CB6300E-6B3A-453B-BA93-50E691F7DF2B03'
WITH BUFFERCOUNT = 24
, BLOCKSIZE = 65536
, MAXTRANSFERSIZE = 1048576 -- 1 MB
, NAME = N'Database (DBName), 19/08/2015 07:50:53'
, DESCRIPTION = N'Backup on 19/08/2015 07:50:53 Server: SQLServer Database: DBName'
, FORMAT
, CHECKSUM

petey

You can configure the MAXTRANSFERSIZE value in 7.6, but up to a value of 1 MB (1048576). In you want to configure the BUFFERCOUNT value, you'll need to use the latest patch version of SQL Backup, available here. The valid range of values is 6 to 65536.

Pixelated_1

Thanks for the response. I'm getting the error

"Forefront TMG: extended error message :

200 Transfer mode set to BINARY
200 Command PORT succeed
426 Transfer failed"

when attempting to download ftp://support.red-gate.com/patches/sql_ ... 7.1.17.exe.

Is this patch stable, as it'll potentially be going to production?

petey

Could you try downloading the patch in a browser instead of using an ftp client?

Would suggest that you wait for an official release if you plan to use the BUFFERCOUNT option, as the patch releases are mainly to address specific user issues.