The other day Aaron Bertrand pointed out that a recent tip I wrote had a rather nasty oversight. You can read more about the discussion over at his blog.
The short of it is this: what I wrote in the tip is cot very clear, and is most likely going to be interpreted wrongly. Aaron’s post does a great job of explaining the difference. I also want people to understand that if you are doing compressed backups, you won’t see much added benefit if you also enable data compression. As Aaron points out in his example, the overall benefit on time and size of the final backup file are comparable whether you are compressing data or not.




