July 7, 2009 at 2:46 pm
Hi,
i'm running SQL 2005 on a Server 2003 box. When I run a backup of my main DB the file is approx 60 gigs. If I zip it afterward, it compresses to 10 gigs. So I was wondering is there a way that I can natively compress my backups all the time? I know there are third party tools out there but I can only use what we have.
Thanks,
TKE402
July 7, 2009 at 2:51 pm
Nope. Native Backup Compression is only available in SQL Server 2008 Enterprise Edition.
July 7, 2009 at 3:14 pm
I'm a fan of setting the compression attribute on the backup directory..
CEWII
July 9, 2009 at 6:08 am
Another option beside compressing the directory would be to use a third party tool, such as Red-Gate's SQL Backup. This includes support for backup compression.
Dave
July 9, 2009 at 8:24 am
The only issue is, when the tape backup is performed, the directory is uncompressed and re-compressed on the tape which makes tape backups take longer.
Server admin guys yell at me if I ever use windows compression!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply