File Paths for SQL Server 2000 (64-bit)
This topic applies only to SQL Server 2000 (64-bit).
An installation of Microsoft® SQL Server™ 2000 (64-bit) can consist of one or more separate instances. These can consist of the default instance and/or one or more named instance. An instance, default or named, has its own set of program and data files as well as common files. The following illustration shows file locations for SQL Server 2000 (64-bit) installed with the default instance and one named instance, Instance1. Both instances have a full set of data and executable files. Common files used by both the default instance and any named instances are installed in the folder systemdrive\Program Files\Microsoft SQL Server\80.
The following figure shows the default locations for installing SQL Server in systemdrive\Program Files\Microsoft SQL Server, normally on drive C.
The location for both the program and data files for the default instance of SQL Server is systemdrive\Program Files\Microsoft SQL Server\Mssql. The default location for the named instance in this case is systemdrive\Program Files\Microsoft SQL Server\Mssql$Instance1. During setup, you can specify a different file path for both the program and the data files. Setup also installs files in the Microsoft Windows® system folder. The location for these system files cannot be changed.
The remainder of this topic details locations for files installed by Setup for SQL Server 2000 (64-bit).
Program and Data File Locations
The program folder is the root folder where Setup creates folders for program and other files that typically do not change as you use SQL Server. These folders do not contain data, log, or backup files, or replication data, so the space required by these files does not change greatly.
Note Data and program files cannot be installed on a removable disk drive.
This data file is the root folder where Setup creates folders that contain database and log files, as well as directories for the system log, backup, and replication data. Setup creates database and log files for the master, model, tempdb, msdb, pubs, and Northwind databases. The SQL Server data file path should be located on a drive with free space available for these files to grow.
Note Data files cannot be installed on a file system using compression.
Each instance of SQL Server has its own program and data files.
Data and Program File Locations for the Default Instance of SQL Server
For the default instance of SQL Server, the default SQL Server program and data folder name (Mssql) is used as the default instance name in the folder that you specify. If you do not specify a location, this is normally in the systemdrive\Program Files\Microsoft SQL Server\ folder. For the default instance of SQL Server, the default directories are:
- systemdrive\Program Files\Microsoft SQL Server\Mssql\Binn (for program files)
- systemdrive\Program Files\Microsoft SQL Server\Mssql\Data (for data files)
During setup, you can change the location for the default instance. For example, if you specify that the default instance be installed at D:\MySqlDir, the file paths are:
- D:\MySqlDir\Mssql\Binn (for program files)
- D:\MySqlDir\Mssql\Data (for data files)
Data and Program File Locations for a Named Instance of SQL Server
Each named instance of SQL Server has a specific location for its program files and another for its data files. These file locations are different from those of the default instance of SQL Server.
Note A named instance is not necessarily the same as a multiple instance. You can have a single named instance or you can have multiple named instances. For more information, see Working with Named and Multiple Instances of SQL Server (64-bit).
For each named instance of SQL Server that you install, with the name instancename, the default directories are:
- systemdrive\Program Files\Microsoft SQL Server\MSSQL$instancename\Binn (for executable files).
- systemdrive\Program Files\Microsoft SQL Server\MSSQL$instancename\Data (for data files).
You can specify file paths other than the default locations for program and data file for named instances. For example, if you specify that the instance named "AnInstance" be installed at D:\MySqlDir, the paths are:
- D:\MySqlDir\MSSQL$AnInstance\Binn (for program files)
- D:\MySqlDir\MSSQL$AnInstance\Data (for data files)
File Locations for Shared Tools
Shared tools are installed by default at systemdrive\Program Files\Microsoft SQL Server\80\Tools. This folder contains files shared by all instances of SQL Server 2000, both the default and any named instances of SQL Server. Tools include this help file (Setupsql.chm), Dev Tools, and other components.
Shared tools that are still in the 32-bit format but used by the 64-bit version of SQL Server are located in systemdrive\Program Files (x86)\Microsoft SQL Server\80\Tools. These files include all of Books Online for SQL Server 2000. This location cannot be changed.
Analysis Services File Locations
Analysis Services includes program files, data files, and the meta data repository. The default location for Analysis Services program files is systemdrive\Program Files\Microsoft Analysis Services\Bin. The default location for the data files is systemdrive\Program Files\Microsoft Analysis Services\Data. The Data folder stores multidimensional data for the objects defined on the Analysis server.
The default locations for both the program and data folders can be changed during setup. However, Analysis Services should not be installed to a folder that uses characters from a double-byte character set (DBCS) in the path or folder name. Install Analysis Services to a folder that uses only single-byte characters in the path and folder name.
In SQL Server 2000 (64-bit), Analysis Services uses SQL Server to host its repository (OLAPRepository.mdf), which stores meta data for objects stored on the Analysis server. The default location for the repository database file is systemdrive\Program Files\Microsoft SQL Server\Mssql$instancename\data, where instancename is the name of the instance with which you install Analysis Services.
Note The Setup program allows installation of only one copy of Analysis Services with a single instance. With the installation of subsequent instances, Analysis Services does not appear on the Feature Selection page of Setup.
When you install Analysis Services, the Setup program also installs the core SQL Server program files to support the Analysis Services repository, even if you do not install the SQL Server components. If you do not want SQL Server and Analysis Services to share the same core SQL Server program files, install Analysis Services in one instance and SQL Server in another instance.
Specifying File Paths
During Setup you can change the installation path for the following features:
|Server Components||\Program Files\Microsoft SQL Server|
|Data Files||\Program Files\Microsoft SQL Server\Mssql\Data|
|Analysis Server||\Program Files\Microsoft Analysis Services|
|Data Files||\Program Files\Microsoft Analysis Services\Data|
|SQL Repository3||\Program Files\Microsoft SQL Server\Mssql\|
|Data Files4||\Program Files\Microsoft SQL Server\Mssql\Data|
1 The default paths shown here are for the default instance. For a named instance, Mssql changes to Mssql$instancename, where instancename is the name of the instance.
2 The default drive for these locations is systemdrive, normally drive C.
3 Specifies the location of the SQL Server program files (if you do not select to install SQL Server Server Components). For more information, see Analysis Services (64-bit).
4 Specifies the location for the Analysis Services repository database. For more information, see Analysis Services (64-bit).
Note When adding features to an existing installation, you cannot change the location of a previously installed feature, nor can you specify the location for a new feature.
When you specify an installation path during Setup for the server components or data files, the Setup program uses the instance name in addition to specified location for program and data files. Setup does not use the instance name for tools and other shared files. Setup also does not use any instance name for the Analysis Services program and data files, although it does for the Analysis Services repository.
Finding Install Locations
If you are uncertain about instance paths, the following registry key provides the path for any named instance:
HKLM\Software\Microsoft\Microsoft SQL Server\instancename\Setup\SQLPath
The following registry key provides the path for the default instance:
You can use the REG QUERY tool available with the 64-bit versions of the Windows® Server 2003 family operating system to query the registry and get the installation path of a particular instance. Run the following at the command prompt, inserting the appropriate instance name:
REG QUERY HKLM\Software\Microsoft\Microsoft SQL Server\instancename\Setup /v SQLPath
Or run the following command for the default instance:
REG QUERY HKLM\Software\Microsoft\MSSQLServer\Setup /v SQLPath
For more information about the REG QUERY tool command syntax, type
REG QUERY /? on the command line.