Red Gate forums :: View topic - SQL Backup 4.2 Build 511 - new keyword MAXTRANSFERSIZE
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup Previous Versions
SQL Backup Previous Versions forum

SQL Backup 4.2 Build 511 - new keyword MAXTRANSFERSIZE

Search in SQL Backup Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
HJoyce



Joined: 10 Oct 2005
Posts: 183

PostPosted: Wed May 10, 2006 5:15 pm    Post subject: SQL Backup 4.2 Build 511 - new keyword MAXTRANSFERSIZE Reply with quote

There is an updated version of the server side components which offers a new keyword, MAXTRANSFERSIZE.

Download from: ftp://ftp.red-gate.com/SQB4.2.0.511.zip

Copy SQBServerSetup.exe and SQLBackupC.exe to the installation directory. To upgrade the server components run SQBServerSetup.exe. Alternatively you can upgrade each instance from the GUI by selecting the SQL Server instance in the left hand panel, right click and select Install/upgrade server components

MAXTRANSFERSIZE indicates to SQL Server the maximum size of each block of memory that it uses to store backup data, prior to SQL Backup compressing/encrypting the data.

Options are:

MAXTRANSFERSIZE = 1048576 (1 MB) (default)
MAXTRANSFERSIZE = 524288 (512 KB)
MAXTRANSFERSIZE = 262144 (256 KB)
MAXTRANSFERSIZE = 131072 (128 KB)
MAXTRANSFERSIZE = 65536 (64 KB)

For example,
master..sqlbackup N'-SQL "BACKUP DATABASE [DatabaseA] TO DISK = ''<AUTO>'' WITH COMPRESSION = 1, MAXTRANSFERSIZE = 524288"'

master..sqlbackup N'-SQL "RESTORE DATABASE [DatabaseA] FROM DISK = ''C:\DatabaseA.sqb''WITH RECOVERY, MAXTRANSFERSIZE = 262144"'

This is particularly useful if you experience an error such as "Failed to close vdi".
In this case the VDI.log will show for example
"Error at ServerBufferAreaManager::Allocate: Map buffers Status Code: 8, x8
Explanation: Not enough storage is available to process this command."


In this case you can use the MAXTRANSFERSIZE keyword with a lower value than the 1MB default, e.g. MAXTRANSFERSIZE = 524288


Last edited by HJoyce on Thu May 11, 2006 6:46 pm; edited 1 time in total
Back to top
View user's profile Send private message Send e-mail
JeffatWork



Joined: 08 May 2006
Posts: 6

PostPosted: Wed May 10, 2006 8:58 pm    Post subject: Reply with quote

I have found the new parameter useful while performing backups. Can we use MAXTRANSFER size with the RESTORE command as well?
Back to top
View user's profile Send private message
HJoyce



Joined: 10 Oct 2005
Posts: 183

PostPosted: Thu May 11, 2006 6:47 pm    Post subject: Reply with quote

Yes, you can using build 511 of the server components.
Back to top
View user's profile Send private message Send e-mail
randyj



Joined: 15 Nov 2005
Posts: 56

PostPosted: Tue Jun 13, 2006 8:45 pm    Post subject: Reply with quote

Despite having just loaded the patch for this, I continue to get errors on backup-
SQL Backup exit code :1050
SQL error code:3202

Write on "SQLBACKUO_<string>" failed: 112(There is not enough space on the disk.)
Failed to close vdi
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2301

PostPosted: Wed Jun 14, 2006 2:43 am    Post subject: Reply with quote

What is the MAXTRANSFERSIZE value that you are using?
_________________
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
Back to top
View user's profile Send private message Send e-mail
randyj



Joined: 15 Nov 2005
Posts: 56

PostPosted: Wed Jun 14, 2006 3:15 pm    Post subject: Reply with quote

Pete-
I tried ALL the suggested values for MAXTRANSFERSIZE, from 1 MB down to 64 KB, and got the same result.
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2301

PostPosted: Wed Jun 14, 2006 4:55 pm    Post subject: Reply with quote

Was the backup file created at all, or maybe part of the file? I'm trying to determine if the backup failed at the very beginning, or midway through the backup. Thanks.
_________________
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
Back to top
View user's profile Send private message Send e-mail
randyj



Joined: 15 Nov 2005
Posts: 56

PostPosted: Wed Jun 14, 2006 4:59 pm    Post subject: Reply with quote

Actually, acting on advice from Brian, I added the 'MAXDATABLOCK = 1048576" parameter, and all seems happy now, woithout using the MAXTRANSFERSIZE parameter.

As I recall, the file was partially created, but I'm not sure how much was written (if any) or if the file was merely created, and not written to.
Back to top
View user's profile Send private message
lslmustang



Joined: 07 Mar 2006
Posts: 4

PostPosted: Tue Jul 18, 2006 8:12 pm    Post subject: question about updating Reply with quote

We have strict security on our browser on the server where our application is located so I get an error that I can't check for updates with the application (we are not allowed to run javascript on the server). Is there an ftp site to get the latest versions instead or is the only way is to download the latest trial version?
Thanks,
Linda
Back to top
View user's profile Send private message
HJoyce



Joined: 10 Oct 2005
Posts: 183

PostPosted: Thu Jul 20, 2006 4:32 pm    Post subject: Reply with quote

Hi.

Yes you can get the latest version from ftp://ftp.red-gate.com/SQLBackupRescueBundle.zip
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group