Upgrade your Internet Experience
Microsoft.com
Welcome Sign in
SQL Server TechCenter
Click to Rate and Give Feedback
TechNet
TechNet Library
SQL Server
SQL Server 2008
Getting Started
 System and Sample Databases

  Switch on low bandwidth view
Community Content
In this section
Statistics Annotations (0)
Other versions are also available for the following:
SQL Server 2008 Books Online (June 2009)
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.

ms143752.note(en-us,SQL.100).gifNote:
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.

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.

Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
© 2009 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Page view tracker