System and Sample Databases

When SQL Server is installed, Setup creates the database and log files shown in the following table.

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

mssqlsystemresource

Mssqlsystemresource.mdf

Mssqlsystemresource.ldf

The system databases are master, model, msdb, mssqlsystemresource and tempdb.

Notes

The default location of the database and log files is Program Files\Microsoft SQL Server\MSQL10.<InstanceName>\MSSQL\. This location will change if the default directory was changed when SQL Server was installed.

Sample Databases

By default, the sample databases are not installed in this SQL Server release. For more information about installing sample databases and sample code, see the CodePlex Web site.

Additional information about samples is available after SQL Server 2008 has been installed. From the Start menu, click All Programs, click Microsoft SQL Server 2008 R2, click Documentation and Tutorials, and then click Microsoft SQL Server Samples Overview.