SQL Server – Understanding the System Databases of SQL Server
We all know there are some system databases available in SQL Server. But we should have understanding about system databases. Here just try to give you understanding of system databases very briefly.
There are four system databases available in SQL Server 2008
- Master
- Model
- msdb
- tempdb
Master Database
The master database records all the system-level information for a SQL Server system.
The master is the database that records the existence of all other databases and the location of those database files and records the initialization information for SQL Server. Therefore, SQL Server cannot start if the master database is unavailable. In short, Master database is the logical repository for the system objects residing in the sys schema.
Model Database
The model database is used as the template for all databases created on the instance of SQL Server. Template can include specific settings and all sorts of useful stuff.
Msdb Database
The msdb database is used by SQL Server Agent for scheduling alerts and jobs. If the MSDB database is corrupted or damaged then scheduling information used by SQL Server Agent will be lost.
Tempdb Database
The tempdb database is a workspace for holding temporary objects or intermediate result sets, temporary table creation/processing. The TempDB is recreated every time when ever SQL Server restarts
For more Detail go to below URL
http://msdn.microsoft.com/en-us/library/ms178028%28v=SQL.105%29.aspx
Pingback: SQL Server CE, tips for usage and issue of corruption « D.T. & Assoc. IT Blog
Resource database is a read-only database that contains system objects that are included with SQL Server. System objects are physically persisted in the Resource database, but they logically appear in the sys schema of every database.