Backup Compression - time for an overhaul

Posted by jchang on SQL Blog See other posts from SQL Blog or by jchang
Published on Fri, 08 Nov 2013 03:29:00 GMT Indexed on 2013/11/08 4:07 UTC
Read the original article Hit count: 226

Filed under:
Database backup compression is incredibly useful and valuable. This became popular with then Imceda (later Quest and now Dell) LiteSpeed. SQL Server version 2008 added backup compression for Enterprise Edition only. The SQL Server EE native backup feature only allows a single compression algorithm, one that elects for CPU efficiency over the degree of compression achieved. In the long ago past, this strategy was essential. But today the benefits are irrelevant while the lower compression is becoming...(read more)

© SQL Blog or respective owner