Compression

sjazic

Does Redgate have its own compression, so that a version of SQL Server without compression, like SQL 2014 Web Edition, will get compressed backups, or does the version of SQL Server have to have backup compression in order for Redgate to be able to compress a backup?

petey2

SQL Backup uses its own compression engine to compress backups, and does not depend on SQL Server's compression support.  You can use SQL Backup to create compressed backups on SQL Server 2000 instances and all subsequent versions.

The only time SQL Backup relies on SQL Server's compression engine is when you need to compress TDE-enabled databases.  In these cases, SQL Backup's compression engine is unable to decrypt and compress the TDE-enabled backup data effectively, and thus relies on SQL Server's support to compress TDE-enabled databases.