This table stores the certificate, encryption, and thumbprint data for each backup encryption scenario you define.
 
Name Type Description
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. 
CertType varchar Certificate type. Valid inputs: BackupEncryption
CertName varchar Certificate name.
EncrAlgorithm varchar Encryption algorithm. For a list of valid inputs, see the list of key_algorithm entries in the MSDN article https://msdn.microsoft.com/en-us/library/ms189446.aspx
ThumbPrint varbinary A globally unique hash of the certificate. See https://msdn.microsoft.com/en-us/library/ms189774.aspx
IsActive bit The current row is valid (active), and should be used in the Minion Backup process.