[AccessD] VLDBs, the saga - Ramblings only

Gustav Brock gustav at cactus.dk
Sat Aug 28 07:47:38 CDT 2004


Hi John

Bad news: No database engine likes a compressed partition as storage
and some do not run reliably at all on such, including SQL Server:

http://www.windowsecurity.com/articles/Secure-Installation-Microsoft-SQL-Server-2000.html

A reminder: the SQL data must not be compressed by the NTFS file
system because this may cause a serious drop in efficiency or even
faults when performing the queries. If you have chosen a compressed
partition, you should halt the SQL service right after the
installation and decompress the data-containing directory    

/gustav


> ..  I then started trying to figure out how to get the drive compressed.




More information about the AccessD mailing list