| Master: |
The master database contains system level information for a
SQL Server 2005 system.
|
| Model: |
The model database is the template that is used when you
create a new database. |
| Msdb: |
The msdb database is used by SQL Server Agent to record information
for scheduling alerts and jobs. |
| Resource: |
The resource database is new in SQL Server 2005 and contains
the system objects for SQL Server 2005. When you update SQL
Server 2005 — for example a service pack — the new version replaces
the resource database. Be careful not to restore an out-of-date version
after applying a service pack. |
| Distribution: |
The distribution database exists only if the SQL Server
machine is a distributor for replication. The database contains metadata
about replication. |
| Temp: |
The temp database is deleted when you close down SQL Server
2005. Although tempdb is a system database, you cannot back it up. |
