here's the URL.. hope this helps...

http://www.databasejournal.com/features/mssql/article.php/3064361

Chava Sreedhar
Singapore
Phone: 6471 5877




"Kumar"
<[Email Address Removed] To: "LazyDBA.com Discussion"
com.sg> <[Email Address Removed]
cc:
11/26/2003 Subject: How to compress DB backup?
02:26 PM
Please respond
to "Kumar"






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



MS Sql Server LazyDBA home page