Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Monday, June 1, 2015 4:23 PM
We are attempting to optimize SQL database backup performance and would like a reply on the following:
The MAXTRANSFERSIZE limit for SQL Server is 4MB. We would like to be able to have a much larger MAXTRANSFERSIZE, on the order of 100GB or even a terabyte so that we can maintain large contiguous database chunks and direct them to one or more tape or disk device targets. This would provide us the benefit of parallelizing database backups in a similar manner to Oracle RMAN channels, which have a SECTION SIZE that can be as large as terabytes in size.
Thank you.
Monday, June 1, 2015 4:46 PM ✅Answered
AFAIK you cannot change max transfer size but you can change Total buffer space. Please read below article
Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it
Tuesday, June 2, 2015 7:39 AM ✅Answered
Hi Jimm,
According to your description, you need to set MaxTransferSize to a large number, right?
MaxTransferSize specifies the unit of transfer to be used by SQL Server from the backup media. It can range from 65536 (65 KB) to 4194304 (4MB). We cannot change it to other number out of the range. To improve the speed of backup operations, there are 2 options we are interested in to optimize our restores: MaxTransferSize and BufferCount. Here is a blog which describes Optimizing SQL Server Backup and Restore.
Charlie Liao
TechNet Community Support