Shut Off Compression?
PaulC
Posts: 9
Hey!
I have multiple databases to back up, and one of them is filled with JPG images that are of couse already compressed. When I use SQL Backup to take a backup of this DB, SQL Backup proudly reports that the backup is 25% larger than they would be using a native SQL backup. ;-)
To have a consistant backup scheme for all DBs, I would like to use SQL Backup on this database, but the 25% size increase makes this impossible.
So, I guess my question is, is there a way to shut off compression when using SQL Backup?
Paul C
I have multiple databases to back up, and one of them is filled with JPG images that are of couse already compressed. When I use SQL Backup to take a backup of this DB, SQL Backup proudly reports that the backup is 25% larger than they would be using a native SQL backup. ;-)
To have a consistant backup scheme for all DBs, I would like to use SQL Backup on this database, but the 25% size increase makes this impossible.
So, I guess my question is, is there a way to shut off compression when using SQL Backup?
Paul C
Comments
Have you tried using compression level 2?
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8
Yikes! :oops: OK, I dont know how I didnt notice that there was a compression level of 0! :oops:
I did try all of the compression levels besides 0, and they were all larger.
Thanks!