Configuring BUFFERCOUNT and MAXTRANSFERSIZE
Pixelated_1
Posts: 6 Bronze 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
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
Comments
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8
"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?
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.
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8