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.
Note
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.
AdventureWorks 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, click Documentation and Tutorials, and then click Microsoft SQL Server Samples Overview.