Shut Off Compression?

PaulC

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

petey

You can use compression level 0 to turn off compression, but note that the backup file will not be usable by SQL Server. You will still need SQL Backup to perform the restore.

Have you tried using compression level 2?

PaulC

Hey!

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!