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.
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.
Topics: Database Backup Products: SQL Safe Backup