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