Post reply

Way to compress SQL 2005 backups natively?

  • July 7, 2009 at 2:46 pm

    #223270

    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

    #1021341

    Nope. Native Backup Compression is only available in SQL Server 2008 Enterprise Edition.

  • July 7, 2009 at 3:14 pm

    #1021354

    I'm a fan of setting the compression attribute on the backup directory..

    CEWII

  • July 9, 2009 at 6:08 am

    #1022292

    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

    #1022398

    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