NT File System

From: Ng K C Paul <paulkcng_at_news.netvigator.com>
Date: 1998/08/27
Message-ID: <6s3he6$3aj$1@imsp009a.netvigator.com>#1/1

What kind of File System should I install the database software and data and log to? FAT or NTFS? I know that the security is better in NTFS. Also, there is a compress option in NTFS. In unix, raw device is more reliable than unix file system which has disk cache that can speed up certain I/O operations. What about performance on NT?

In WIN97/98, there is also FAT32. Should I use it to install MS-SQLServer 7.0, Personal Oracle8 or Adaptive SQLServer Anywhere Studio? It seems that FAT32 can save more space than FAT but NT4.0 cannot read files on FAT32, am I right? Also, is there any difference on backup and recovery time on different file system? Received on Thu Aug 27 1998 - 00:00:00 CDT