How to compress SQL Backups

Question

Post reply

How to compress SQL Backups

Martin Balbo

SSC Eights!

Points: 874
More actions
July 6, 2006 at 7:39 am

#115757

Hi friends.
I make a script to do backup of my sqlserver 2000 using DMO (First, backup and the connect to network share and copy the files). Now the database backup files are very large and i need to compress using a command line "zipper" before copying. Anyone knows where can i get an utility (free) to do this?

Thanks for the advice.

Viewing 9 posts - 1 through 8 (of 8 total)

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

lucky-80472 SSCertifiable Points: 7793 More actions · Answer 1

Hello Martin,

You can go ahead with WinZip Command Line Support Add-On.

Thanks and have a good day!!!

Lucky

Martin Balbo SSC Eights! Points: 874 More actions · Answer 2

Thanks for help, but the Operating system administrators dont want to install the Winzip (Licence Problems...). I tried using the zip.exe file included in Oracle 9i Client, but it only works with files lower than 2 GB.

Do u have any other idea?

Thanks for help

Ivan McAvinchey SSC Rookie Points: 28 More actions · Answer 3

There are plenty of free command line zippers that can be found with a simple Google query. Have a look for example at these two:

http://www.7-zip.org/

http://www.freebyte.com/fbzip/

HTH

Josep SSCommitted Points: 1518 More actions · Answer 4

gzip has also a nice command line and it's just a file, so easy to use. No installation needed. I like it 🙂

Josep.

Martin Balbo SSC Eights! Points: 874 More actions · Answer 5

Many thanks for help. I used gzip and works great!

Regards.

CGSJohnson SSCertifiable Points: 7208 More actions · Answer 6

How large are your back-up files (just curious)? Wasn't there some thread of not compressing back-up files? Is this a non-issue now?

Thanks...Chris

Mark Harr SSCrazy Eights Points: 9921 More actions · Answer 7

You might consider using 3rd party backup software like SQL LiteSpeed, that will compress the backup as it gets written. That gets you faster backup and smaller file, and you won't need to compress it after it's created.

Mark

Martin Balbo SSC Eights! Points: 874 More actions · Answer 8

Thanks, but we dont have enough budget to adquire this kind of tools. So, we used DMO to make backups with scripting and then programming the job in SQL (Thanks this website for the dmo help!) . Once finished, we use gzip to compress the backups in disks. We make some recovery test and works great, no problems in file consistency.

For Chris, we have 60 database in the most critical server, the bigger is around 35 GB, total backup is around 120 GB.

Thanks to all!