Whitepaper : Database Backup Compression Versus File Deduplication

Database administrators often argue with their storage administrators about not compressing database backups. Storage administrators state that they can get better file deduplication from storage devices such as EMC Data Domain. Storage administrators often tell database administrators not to compress their database backups.

This whitepaper discusses why not compressing database backups is likely a terrible idea. In particular, the whitepaper discusses what file deduplication is, why file deduplication slows backup and database restores, why the storage administrator is wrong, and why deduplication of compressed and encrypted data does not work well.

Author: Stan Geiger

Stan Geiger is Director, Product Management, Multiple-Platform Tools at Idera, Inc. He has over 25 years of experience using Microsoft SQL Server. He has worked in various industries including finance, healthcare, energy, and the US Department of Defense. Stan has held several positions including database developer, database administrator, and business intelligence architect. His experience lies in building data warehouses and extract, transform, and load (ETL) platforms, business intelligence analytics, and online transaction processing (OLTP) systems.

Register to read the full whitepaper.

See Also:

Topics : Database Backup,

Products : SQL Safe Backup,

Register for Free Whitepaper

Note: By filling and submitting this form you understand and agree that the use of IDERA’s website is subject to the General Website Terms of Use. Additional details regarding IDERA’s collection and use of your personal information, including information about access, retention, rectification, deletion, security, cross-border transfers and other topics, is available in the Privacy Policy.