Purpose

This table holds the thresholds used to determine when to change the tuning of a backup.
For more information, see the sections “About: Dynamic Backup Tuning Thresholds” and “How to: Set up dynamic backup tuning thresholds”.
 
Column Name Data Type Definition
ID int Primary key row identifier.
DBName sysname Database name.
BackupType Varchar Backup type. Valid inputs:  ALL, Full, Diff, Log.  Note that ALL encompasses full, differential, and log backups.
SpaceType varchar The way in Minion Backup determines the size of the database (e.g., data only, data and index, etc.) Note that this column is  ignored for log backups, but you should put “Log” here anyway for rows where BackupType=Log, because it’s descriptive.  Valid inputs: DataAndIndex, Data, File, Log
ThresholdMeasure char The measure for our threshold value. Valid inputs: GB
ThresholdValue bigint The correlating value to ThresholdMeasure. So. if ThresholdMeasure is GB, then ThresholdValue is the value – the number of gigabytes.
NumberOfFiles tinyint The number of files to use for the backup.
Buffercount Smallint From MSDN.Microsoft.com: “Specifies the total number of I/O buffers to be used for the backup operation. You can specify any positive integer; however, large numbers of buffers might cause "out of memory" errors because of inadequate virtual address space in the Sqlservr.exe process.”
MaxTransferSize bigint Max transfer size, as specified in bytes. This must be a multiple of 64KB. Note that a value of 0 will allow Minion Backup to use the SQL Server default value, typically  1MB.

From MSDN.Microsoft.com:  “Specifies the largest unit of transfer in bytes to be used between SQL Server and the backup media. The possible values are multiples of 65536 bytes (64 KB) ranging up to 4194304 bytes (4 MB).”
Compression bit From MSDN.Microsoft.com: “In SQL Server 2008 Enterprise and later versions only, specifies whether backup compression is performed on this backup, overriding the server-level default.”
BlockSize bigint From MSDN.Microsoft.com: “Specifies the physical block size, in bytes. The supported sizes are 512, 1024, 2048, 4096, 8192, 16384, 32768, and 65536 (64 KB) bytes. The default is 65536 for tape devices and 512 otherwise. Typically, this option is unnecessary because BACKUP automatically selects a block size that is appropriate to the device. Explicitly stating a block size overrides the automatic selection of block size.”
BeginTime varchar The start time at which this threshold applies.

IMPORTANT: Must be in the format hh:mm:ss, or hh:mm:ss:mmm (where mmm is milliseconds), on a 24  hour clock. This means that both ’00:00:00’ and ’08:15:00:000’ are valid times, but ‘8:15:00:000’  is not (because single digit hours must have a leading 0).
EndTime varchar The end time at which this threshold applies.

IMPORTANT: Must be in the format hh:mm:ss, or hh:mm:ss:mmm (where mmm is milliseconds), on a 24  hour clock. This means that both ’00:00:00’ and ’08:15:00:000’ are valid times, but ‘8:15:00:000’  is not (because single digit hours must have a leading 0).
DayOfWeek Varchar The day or days to which the settings apply. Valid inputs: Weekday, Weekend, [an individual day, e.g., Sunday]
IsActive Bit Whether the current row is valid (active), and should be used in the Minion Backup process.
Comment Varchar For your reference only. You can label each row with a short description and/or purpose.