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)
 NTFS compression and MS SQL Server 2000

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-07-11 : 06:20:24
Warner writes "Will enabling NTFS compression on a volume, folders, and all files with an installation of MS SQL Server 2000 sp3 create any problems? Would this cause database backup files created using 'BACKUP DATABASE' to be unusable? Is NTFS compression a good alternative to purchasing more disk space?"

robvolk
Most Valuable Yak

15732 Posts

Posted - 2005-07-11 : 06:24:12
It's not recommended:

http://blogs.msdn.com/khen1234/archive/2005/04/25/411852.aspx

There are several backup compression utilities for SQL Server:

http://www.imceda.com/
http://www.idera.com/

However the data and transaction log files cannot be compressed with it, and should not be compressed anyway.
Go to Top of Page
   

- Advertisement -