SQL Server Performance

Zipping the backup file

Discussion in 'General DBA Questions' started by danny123, Mar 9, 2007.

  1. danny123 New Member

    Hi there

    We are taking the backup of a database on on server and then move that backup file to other server. Its about 6 Gb and takes about 15 min to tranfer. I am thinking of zipping the file which will make it to 1 gb and then transfer it. Will zipping cause any harm to the backup file.

    Thanks
    Danny
  2. khtan New Member

    No. I use WinRAR / WinZIP to compress the backup file all the time


    KH
  3. FrankKalis Moderator

    The zipping itself should not in and of itself have any negative impact on the backup. There are third-party backup tools, which even include such a compression feature. It might make sense for you to check out the tools section here. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />--<br />Frank Kalis<br />Moderator<br />Microsoft SQL Server MVP<br />Webmaster:<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a>
  4. dineshasanka Moderator

  5. danny123 New Member

    Can someBody suggest any tool..useful in this scenario.

    Thanks
    Danny
  6. dineshasanka Moderator

  7. MohammedU New Member

    Zipping should not cuase any problem but if you use third party your backup and restore time also fater than native along with smaller file size....

    I use LiteSpeed to backup VLDB databases....


    MohammedU.
    Moderator
    SQL-Server-Performance.com

Share This Page