Video Screencast Help
Scheduled Maintenance: Symantec Connect is scheduled to be down Saturday, April 19 from 10am to 2pm Pacific Standard Time (GMT: 5pm to 9pm) for server migration and upgrade.
Please accept our apologies in advance for any inconvenience this might cause.

About MAXTRANSFERSIZE parameter in SQL backup script

Created: 08 Aug 2013 • Updated: 09 Aug 2013
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:

http://www.symantec.com/business/support/index?page=content&id=TECH33423

http://searchitchannel.techtarget.com/feature/SQL-Server-2005-Practical-Troubleshooting

http://blogs.msdn.com/b/psssql/archive/2008/01/28/how-it-works-sql-server-backup-buffer-exchange-a-vdi-focus.aspx