System and Sample Databases
The document is archived and information here might be outdated

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.

Show:
© 2016 Microsoft