Sql Server Default Databases

By default we will used to have five databases they are

Master Database:

1.The Master database is the heart of SQL Server.
2, It basically records all the system level information.
3,Every instance of SQL Server will have an independent Master database;
4. The system and user databases related information such as name and location for user and system database are captured in Master database.
5.The Master database basically consists of two physical files, namely master.mdf (data file) and mastlog.ldf (log file).
6.The database id is 1

Model Database:

1.The Model database is basically used as a template when creating databases in SQL Server.
2.The database id is 3

MSDB Database:

1.SQL Server Agent uses MSDB database to store information related to the configuration of SQL Server Agent Jobs, Job schedules, Alerts, Operators etc.
2. MSDB also stores information related to configuration of Service Broker, Log Shipping, database backups and restore information, Maintenance Plan Configuration, Configuration of Database Mail.
3. This database also stores SSIS packages created in SQL Server 2005 & 2008.
4. The database id is 4.

TempDB Database:

1.The TempDB is the only database in SQL Server which is recreated every time when SQL Server restarts.
2.It basically stores all the temporary objects such as temporary tables, global temporary tables, temporary stored procedures, cursors, table variables,Triggers.
3.The database id is 2
.
Resource Database:
1.The Resource database is a read only, hidden system database that contains all the SQL Server system objects such as sys.objects which are physically available only in the Resource database, even though they logically appear in the SYS schema of every database.
2, Resource Database does not contain any user data or any user metadata.
3. The database id is 32767.

Thanks
GSV