As far as I know there's no native SQL Server command to compress backup
files. You could however, compress the backup directory within Windows
itself, so any file that is put in that directory is compressed by default.

There's a good 3rd party tool that I'm testing at the moment called SQLLite
(http://www.sqltools.co.uk/Default.asp?page=48 ) There's a trial version
there which you could use. The backup size of my database has reduced
dramatically (from 19GB to 5GB).


-----Original Message-----
From: Kumar [mailto:[Email Address Removed]
Sent: Wednesday, November 26, 2003 6:27 AM
To: LazyDBA.com Discussion
Subject: How to compress DB backup?


Dear Friends,

I am running SQL Server 2000 on Windows2000 Server. As my databases are
growing, I wanna compress the backup file and write to the tape drive. While
I searched , I have options like 'SQLZIP' , 3rd party tool or a Windows2000
compressed folder.

Is there any native SQL Server command to compress the backup files? Please
shed some light

Regards
Kumar


**********************************************************************
This is a commercial communication from Commerzbank AG.

This communication is confidential and is intended only for the person to
whom it is addressed. If you are not that person you are not permitted to
make use of the information and you are requested to notify
<mailto:LONIB.[Email Address Removed] immediately that you have
received it and then destroy the copy in your possession.

Commerzbank AG may monitor outgoing and incoming e-mails. By replying to
this e-mail you consent to such monitoring. This e-mail message and any
attached files have been scanned for the presence of computer viruses.
However, you are advised that you open attachments at your own risk.

This email was sent either by Commerzbank AG, London Branch, or by
Commerzbank Securities, a division of Commerzbank. Commerzbank AG is a
limited liability company incorporated in the Federal Republic of Germany.
Registered Company Number in England BR001025. Our registered address in
the UK is 23 Austin Friars, London, EC2P 2JD. We are regulated by the
Financial Services Authority for the conduct of investment business in the
UK and we appear on the FSA register under number 124920.

**********************************************************************

MS Sql Server LazyDBA home page