System and Sample Databases

When Microsoft® SQL Server™ is installed, SQL Server Setup creates these database and log files.

Database Database file Log file
master master.mdf mastlog.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

master, model, msdb, and tempdb are system databases. Northwind and pubs are sample databases that are provided as learning tools. Most of the examples in the SQL Server documentation are based on these databases. The sample databases are not installed in an embedded installation.


Note The default location of the database and log files is \Mssql7\Data. The location may vary if the default location was changed when SQL Server was installed.


See Also

System Databases and Data

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.