When Microsoft® SQL Server™ is installed, SQL Server Setup creates these database and log files.
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 |
pubs | pubs.mdf | pubs_log.ldf |
Northwind | northwnd.mdf | northwnd.ldf |
master, model, msdb, and tempdb are system databases. Northwind and pubs are sample databases that are provided as learning tools. Most of the examples in the SQL Server documentation are based on these databases. The sample databases are not installed in an embedded installation.
Note The default location of the database and log files is \Mssql7\Data. The location may vary if the default location was changed when SQL Server was installed.