Configuring BUFFERCOUNT and MAXTRANSFERSIZE

Pixelated_1Pixelated_1 Posts: 6 Bronze 1
edited September 7, 2015 9:28PM in SQL Backup Previous Versions
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
· Share on Twitter

Comments

  • peteypetey Posts: 2,358 New member
    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.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
    · Share on Twitter
  • Pixelated_1Pixelated_1 Posts: 6 Bronze 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?
    · Share on Twitter
  • peteypetey Posts: 2,358 New member
    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.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
    · Share on Twitter
Sign In or Register to comment.