







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.
![]() |
---|
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. |
AdventureWorks Sample Databases
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.