See Also
When SQL Server is installed, Setup creates the database and log files shown in the following table.
| Database | Database file | Log file |
|---|---|---|
|
|
Master.mdf |
Mastlog.ldf |
|
|
Model.mdf |
Modellog.ldf |
|
|
Msdbdata.mdf |
Msdblog.ldf |
|
|
Tempdb.mdf |
Templog.ldf |
|
|
Mssqlsystemresource.mdf |
Mssqlsystemresource.ldf |
The system databases are
 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
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.
See Also
Tasks
Considerations for Installing SQL Server Samples and Sample DatabasesConcepts
Installing SQL Server 2008Upgrading to SQL Server 2008