Any reason NOT to compress log backups?

• Beatrix Kiddo

  SSC-Dedicated

  Points: 32407

  More actions

  September 20, 2013 at 4:22 am

  #298120

  I'm not finding much when I Google it.

  Thanks

• kevaburg

  SSCoach

  Points: 18131

  More actions

  September 20, 2013 at 5:41 am

  #1651862

  Compressing a log backup does nothing really more than make the final file size smaller than its uncompressed form. It will take slightly longer to do depending on how big the log is and there will be some overhead as a result of the compression operation but apart from that, I can think of no real reason why the log backup should not be compressed.

• Beatrix Kiddo

  SSC-Dedicated

  Points: 32407

  More actions

  September 20, 2013 at 6:02 am

  #1651871

  Thanks. I'm feeling cautious so I thought I'd better double-check!