Backup Compression in sql server 2000

• nikhil.verma

  SSCrazy

  Points: 2603

  More actions

  December 24, 2008 at 12:45 pm

  #125303

  Hi

  How can be compress backups using sql server 2000.

  I have tried installing winrar and tried to compress the .bak file using command line but it is not working.

  Please let know if there is any way out for this.

  Thanks

• Perry Whittle

  SSC Guru

  Points: 234013

  More actions

  December 24, 2008 at 12:50 pm

  #917541

  there are some freebiee sql utils but the best bet is either Redgate SQL Backup or Quest Litespeed?

  -----------------------------------------------------------------------------------------------------------

  "Ya can't make an omelette without breaking just a few eggs" 😉

• Michael Valentine Jones

  SSC Guru

  Points: 64818

  More actions

  December 24, 2008 at 12:54 pm

  #917543

  There are a number of commercial utilities that let you produce compressed SQL Server backups:

  SQL LiteSpeed, Redgate Backup, Idera has one, and there are several others.

  Another option might be to upgrade to SQL Server 2008 Enterprise Edition because it has native backup compression built-in.