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. 