Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 compressing backups?

Author  Topic 

skyfire1
Starting Member

4 Posts

Posted - 2004-01-30 : 11:52:34
Is there a way that I can compress a database backup while it is dumping? Is there a built in tool in MSSQL 2K?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-01-30 : 12:28:13
No built in tool. SQL Litespeed is a third party product that you can use to get your database backup file sizes down. We've got it. One of our database backup files used to be about 130GB. Now it's 30GB! Saved us a lot of space on the SAN, which is very expensive for disks.

Tara
Go to Top of Page
   

- Advertisement -