Export (0) Print
Expand All

System and Sample Databases (64-bit)

SQL Server 2000

  This topic applies only to SQL Server 2000 (64-bit).

When Microsoft® SQL Server™ 2000 (64-bit) is installed, Setup creates the databases and log files shown in this table.

Database Database file Log file
master Master.mdf Mastlog.mdf
distmdl Distmdl.mdf Distmdl.ldf
model Model.mdf Modellog.ldf
msdb Msdbdata.mdf Msdblog.ldf
tempdb Tempdb.mdf Templog.ldf
pubs Pubs.mdf Pubs_log.ldf
Northwind Northwnd.mdf Northwnd.ldf

The following Analysis Services database files appear only in the instance with which Analysis Services is installed.

Database Database file Log file
olapquerylog OLAPQueryLog.mdf OLAPQueryLog.ldf
olaprepository OLAPRepository.mdf OLAPRepository.ldf
Foodmart 2000 Foodmart 2000.mdf Foodmart 2000.ldf

The default location of the database and log files is systemdrive\Program Files\Microsoft SQL Server\Mssq\Data for the default instance, and systemdrive\Program Files\Microsoft SQL Server\Mssq$instancename\Data for a named instance. The databases installed with an instance may not include all those shown above, depending on the features installed with the instance.

The system databases are master, distmdl, model, msdb, and tempdb. The sample databases, pubs, Northwind, and Foodmart 2000 are provided as learning tools. (Names of these databases are case sensitive.) Many of the examples in SQL Server Books Online are based on the sample databases.

© 2014 Microsoft