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
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>
Red gate sql Backup compress and encrypt your backups http://www.red-gate.com/products/SQL_Backup/index.htm ---------------------------------------- Contributing Editor, Writer & Forums Moderator http://www.SQL-Server-Performance.Com Visit my Blog at http://dineshasanka.spaces.live.com/
http://www.sql-server-performance.com/software_spotlights/hg_sqlbackup.asp http://www.sql-server-performance.com/da_redgate_sql_backup_spotlight.asp ---------------------------------------- Contributing Editor, Writer & Forums Moderator http://www.SQL-Server-Performance.Com Visit my Blog at http://dineshasanka.spaces.live.com/
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
