Video Screencast Help
Backup and Recovery Community Blog

About MAXTRANSFERSIZE parameter in SQL backup script

Created: 08 Aug 2013 • Updated: 09 Aug 2013 • 1 comment
Wiriadi Wangsa's picture
0 0 Votes
Login to vote

First, I just want to clarify that MAXTRANSFERSIZE is not a NetBackup-specific code/parameter.

Rather, it's a standard parameter used by Microsoft SQL virtual device (VDI) during backup/restore. Pretty much any backup tool that backs up Microsoft SQL database can use this parameter for tuning purpose. In older NetBackup version, the default value we used was 64KB (the minimum) unless user specified otherwise. Newer NetBackup version (6.5.x, 7.x.x) defaults to 4MB (the maximum) as it improves backup performance and more servers have bigger physical memory. 

The following links should hopefully help you understand the parameter better:

Comments 1 CommentJump to latest comment

Wiriadi Wangsa's picture

Within the backup/restore script, You can specify MAXTRANSFERSIZE value of 0 up to 6.

The calculation is as follows: 

0 = 64 kilobytes

1 = 64 kilobytes * 2^1 = 128 kilobytes



6 = 64 kilobytes * 2^6 = 4 MB

Login to vote