Backup compression behavior when appending backups to an existing Media Set

 There will be an upcoming Knowledge base article detailing this out as well  When you append a compressed backup to an existing Media, it inherits the compression setting from the Media set.  If you rely on the ‘backup compression’  sp_configure setting and are appending to existing media sets you may end up with a backup…