What are the challenges you face when working across database platforms? Take the survey

Shut Off Compression?

PaulCPaulC Posts: 9
edited July 10, 2006 12:20PM in SQL Backup Previous Versions

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


  • Options
    peteypetey Posts: 2,358 New member
    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?
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options

    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.

Sign In or Register to comment.