How can we help you today? How can we help you today?

Configuring BUFFERCOUNT and MAXTRANSFERSIZE

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
Pixelated_1
0

Comments

3 comments

Sort by
  • 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.
    petey
    0
  • 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?
    Pixelated_1
    0
  • 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.
    petey
    0

Add comment

Please sign in to leave a comment.