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 registering, you confirm that you agree to the processing of your personal data by Idera, Inc. as described in the Privacy Statement.
Idera, Inc. is part of the Idera group and may share your information with its parent company Idera, Inc., and its affiliates. For further details on how your data is used, stored, and shared, please review our Privacy Statement.