Post reply

backup tool

  • February 13, 2012 at 7:51 am

    #268215

    Do you guys know if any back up tool which can compress the blob data, to my understanding most of the thord party tools compress the text data not the blob data?

    Thanks

  • February 13, 2012 at 8:15 am

    #1446271

    Many types of blob data are already compressed, for example, a .PDF file. Other types of blob data are not compressed.

    There is no tool that can compress data that is already compressed.

  • February 13, 2012 at 8:57 am

    #1446307

    you might look into Litespeed, you can adjust the level of compression.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • February 13, 2012 at 9:09 am

    #1446316

    I think you're mixing up backup compression and database compression. Backup compression compresses the backup and does not care what is in the backup. As far as the backup process is concerned a page is a page and is not interrogated to see what kind of page it is

    It's database compression in SQL 2008 does not compress the LOB data types.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply