Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

System and Sample Databases

Updated: 5 December 2005

When SQL Server 2005 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

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

ms143752.note(en-US,SQL.90).gifNote:
The default location of the database and log files is Program Files\Microsoft SQL Server\Mssql.n\MSSQL\Data, where n is the ordinal number of the SQL Server instance. This location may vary if the default location was changed when SQL Server was installed.

The sample databases are provided as learning tools, but are not installed by default in the SQL Server 2005 release. For more information on AdventureWorks sample databases, see Running Setup to Install AdventureWorks Sample Databases and Samples.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.