Sample Header Ad - 728x90

Backup tuning for large databases

6 votes
2 answers
2491 views
I am tuning SQL Server backups using compression, writing to multiple files, and changing the BufferCount and MaxTransferSize options. I have a SQL Server instance with a 4 TB database and several smaller databases from a few MB to 150 GB. My question is, can I start tuning with the 150 GB DB and then apply those settings to the 4 TB backup with minimal changes, or does the 4 TB require its own "tuning session" from scratch? Since it usually takes several backup attempts to dial in the settings I'm trying to get a jump-start on tuning the 4 TB database if possible.
Asked by Dave M. (103 rep)
Nov 12, 2014, 04:32 PM
Last activity: Feb 6, 2023, 04:04 PM