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. Perhaps now is a good time to find out why not compressing database backups is likely a bad idea.
Read the 5-page whitepaper “Database Backup Compression Versus File Deduplication” to learn why compression of database backups yields better results than file deduplication with storage appliances.
SQL Safe Backup creates backups faster and saves space via dynamic compression with encryption. Advanced compression, disk writing, and multi-threading technologies significantly increase the backup speed. The IntelliCompress technology continually samples the system resource usage and automatically adjusts the compression level to ensure the smallest backup files in the fastest time given the state of the environment. Secure backups by using encryption via the 128-bit and 256-bit advanced encryption standard (AES) with a performance degradation of less than 0.5%. Backup and restore with low impact by running SQL Safe Backup as a separate process outside of the SQL Server process space. Backup to and restore from EMC Data Domain servers, and permanently store backup files to IBM Tivoli Storage Manager (TSM) to adhere to corporate storage standards.