How to check the compression ratio before going to perform Backup with Compression option?Ĭan we set the ratio(value) to backup compression? So it's an important difference, more than 60% in my case (and I think with other utilites like ZIP can be even bigger) if you need to store those backups on a long term. SQL normal backup of 17 GB archived directly as RAR result in a 1.6GB file SQL compression backup is 2.9GB and archiving as RAR (for example) you get a 2.6 GB file For example a 'normal' database (no jpgs, etc, just basic data types) with a backup of 17 GB: The only real downsize of the compressed backup with SQL is that the file cannot be optimally compressed further with other utilities. In rar backup we can't restore when ever need.įor compressing large data rar takes more time. The main purpose of taking backup is when ever required.
Can we further compress backups while using native backups beyong the point sql engine compresses the backup using the compression setting ?
