backup compression sql server percentage code example Example: SQL FULL BACKUP COMPRESSION SIZE SELECT backup_size/compressed_backup_size FROM msdb..backupset;