Locating Directories and Files

Installing SQL Server

Installing SQL Server

Locating Directories and Files

The following tables and illustration show the default locations of directories and files for Microsoft® SQL Server™ 2000 (primarily for the default instance). Depending on the options you install, all of the files listed in the tables may not appear on your computer, and others not listed may be included.

Paths listed here are default paths, and may vary if locations were changed during installation. Both program and data file locations can be changed, but the location of shared tools cannot be changed.

Important  Do not delete any of the following directories or their contents: Binn, Data, Ftdata, HTML, or 1033. You may delete other directories, if necessary; however, you may not be able to retrieve any lost functionality or data without uninstalling and reinstalling SQL Server 2000.

Do not delete or modify any of the .htm files in the HTML directory. They are required for SQL Server Enterprise Manager and other tools to function properly.

Shared Files for All Instances of SQL Server 2000

This table shows the locations for the shared files for both default and named instances of SQL Server 2000.

Location Description
\Program Files\Microsoft SQL Server\80\Com Dynamic-link libraries (DLLs) for Component Object Model (COM) objects.
\Program Files\Microsoft SQL Server\80\Com\Binn\Resources\1033 Resource files (RLLs) used by the DLLs in this COM directory. (Note: 1033 is for U.S. English; localized versions use different directory numbers.)
\Program Files\Microsoft SQL Server\80\Tools\Binn Microsoft Windows NT® client executable files.
\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033 Resource files used by the DLLs in the Tools\Binn directory.
\Program Files\Microsoft SQL Server\80\Tools\Books SQL Server Books Online files, including online Help files.
Program Files\Microsoft SQL Server\80\Tools\DevTools\ Header files, library files, and sample programs for use by developers.
Program Files\Microsoft SQL Server\80\Tools\Html Microsoft Management Console (MMC) and SQL Server HTML files.
Program Files\Microsoft SQL Server\80\Tools\Templates Boilerplate files with SQL scripts to help you create objects in the database.
Program and Data Files for the Default Instance of SQL Server 2000

This table shows the locations of the program and data files for the default instance of SQL Server 2000. These are the default file locations, which can be changed during installation.

Location Description
\Program Files\Microsoft SQL Server\Mssql\Backup Default location for backup files.
\Program Files\Microsoft SQL Server\Mssql\Binn Microsoft Windows NT server executable files and DLL files for extended stored procedures.
\Program Files\Microsoft SQL Server\Mssql\Binn\Resources\1033 Resource files used by the DLLs in this Binn directory.
Program Files\Microsoft SQL Server\Mssql\Data System and sample database files.
Program Files\Microsoft SQL Server\Mssql\Ftdata Full-text catalog files.
Program Files\Microsoft SQL Server\Mssql\Install Scripts run during Setup and resulting output files.
Program Files\Microsoft SQL Server\Mssql\Jobs Storage location for temporary job output files.
Program Files\Microsoft SQL Server\Mssql\Log Error log files.
Program Files\Microsoft SQL Server\Mssql\Repldata Working directory for replication tasks.
Program Files\Microsoft SQL Server\Mssql\Upgrade Files used for version upgrade from SQL Server version 6.5 to SQL Server 2000.

File Locations for the Default Instance of SQL Server 2000

This illustration shows the file locations for the default instance of Microsoft® SQL Server™ 2000.

See Also

File Paths for SQL Server 2000