SQL Server Performance

compression in backups

Discussion in 'Third Party Tools' started by griggsy21, Nov 6, 2006.

  1. griggsy21 New Member

    Is there not a way to backup a database and compress the .mdf while it is backing up? Do I have to invest in a third party tool like Red-Gate's SQL Back or Idera's SQLSafe? If I use zip to compress...there is really no performance or storage saving. Is there anything on the market more efficient than winzip that will compress the .bak during the backup process?
  2. Luis Martin Moderator

    3rt party tool like Reg Gate SQL Backup. I used a lot and no problems.



    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All in Love is Fair
    Stevie Wonder


    All postings are provided “AS IS” with no warranties for accuracy.



  3. satya Moderator

    http://www.sql-server-performance.com/sqlzip_spotlight.asp

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.
  4. joechang New Member

    if you do not want to pay for a 3rd party product, you write your own SQL backup compression utility
    search the MS site for VDI, there is a sample program on how to use VDI for backup
    then go to Source Forge to find some good open source compression utilities
    figure this would take you about 1 week for a basic tool,
    you are on your own for support

    or you could pay for the 3rd party product with support
  5. satya Moderator

    How big is the database backup file you're talking here?

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.
  6. griggsy21 New Member

    Actually...I am doing backups from a couple dozen servers...all .bak's ranging in size from 5-28GB. On average, I would say 15GB in size. I was looking at the sqlzip article. That solution looks very feasible for me at this time.
  7. satya Moderator

    Also have look around Spotlight on other tools that might help you.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.

Share This Page