Unless you're using TDE then compression prior to 2016 can be bad. ( or so I've read, I don't care to tempt it myself )
Just to give you some confidence in this area, we've been using non-TDE compressed backups since 2015 (that's when we upgraded from 2005 to 2012). I can't speak for 2008/2008R2 (we skipped over those) but we've never had a problem with compressed backups and I do a couple of restores from backups every single night. We upgraded to 2016 right after SP1 came out and, still, no problems with compressed backups or restores.
I would, however, be interested in any links you might still have that have made the claim so that I know what to keep my eye out for.
is pronounced "ree-bar
" and is a "Modenism
" for R
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
"Change is inevitable... change for the better is not".
"Dear Lord... I'm a DBA so please give me patience because, if you give me strength, I'm going to need bail money too!"
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)