Jun 19 2022
BACKUP DATABASE AdventureWorks
TO DISK = 'C:\AdventureWorks.BAK'
WITH STATS = 1, COMPRESSION, CHECKSUM, buffercount=20, maxtransfersize=2097152
buffercount = NumberofBackupDevices* 3 + NumberofBackupDevices + (2 * NumberofVolumesInvolved)
I read at many places but, I really don’t get 100% of what is mentioned above to calculate buffercount, please help me to understand it, as I am not an expert in SQL administration.
Also, is there an impact of the SQL version on buffercount?