Export (0) Print
Expand All

File Systems

SQL Server 2000

Server performance is not affected by the file system used (FAT or NTFS). Your choice of file system should be determined by factors other than performance.

  • The File Allocation Table (FAT) file system allows dual booting with computers running Microsoft® MS-DOS®, Microsoft Windows® 95, or Microsoft Windows 98.

  • The Microsoft Windows NT® file system (NTFS) has security and recovery advantages.

    If you do not need to dual-boot Windows NT or Windows 2000 with MS-DOS, Windows 95, or Windows 98, NTFS is recommended.

Warning  Microsoft SQL Server™ 2000 data and transaction log files must not be placed on compressed file systems.

For more information about choosing the appropriate file system, see the operating system documentation.

Note  When running on Windows NT, SQL Server performance can be improved further if the databases are created on disks formatted using NTFS and, specifically, 64-KB extent sizes. In Windows 2000, setting the file system cluster size to 64-KB extent size using the /A format option will also improve performance. For more information about formatting an NTFS disk, see the Windows NT or Windows 2000 documentation.

© 2014 Microsoft