SQL monitor database and Table compression
The compression estimates show about 56% size reduction for the top 20 tables by size.
However, it would be nice to know from the horse's mouth if this is viable going forward.
FYI We monitor some 25 busy production servers that with default purge settings of 3 months have some 500GB of database.
So table compression giving a 56% reduction would be great, if it doesn't all stop working!