Re: NT File System

From: Neil Pike <100577.553_at_compuserve.com>
Date: 1998/08/28
Message-ID: <VA.000006b0.0022f993@neilpikeport>#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?

Ng,

FAT is marginally better for writes, NTFS for reads, but really there's not much difference. You can use raw partitions with SQL 6.x, but I wouldn't recommend it - too much of a pain for minimal gain.

>
> 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?

SQL is file system independent, so FAT32 should work fine. You can read FAT32 on NT with a 3rd party driver from www.sysinternals.com

Neil Pike MVP/MCSE
Protech Computing Ltd Received on Fri Aug 28 1998 - 00:00:00 CDT