What Are The Basic Functions For Master, Msdb, Model, Tempdb And Reso

1.	What Are The Basic Functions For Master, Msdb, Model, Tempdb And Resource System Databases?
Answer» The master database holds information for all databases located on the SQL Server instance. As SQL Server cannot start without a functioning master database, we must administer this database with care and monitor Startup Parameters in Configuration Manager. The MSDB database stores information regarding database backups, SQL Agent information, DTS packages, SQL Server jobs, and some replication information such as for log shipping. The tempdb holds temporary objects such as global and local temporary tables and STORED procedures. The model is essentially a template database USED in the creation of any new user database created in the instance. The resource Database is a read-only database that contains all the system objects that are INCLUDED with SQL Server. SQL Server system objects, such as sys.objects, are physically persisted in the Resource database, but they logically appear in the sys schema of every database. The Resource database does not CONTAIN user data or user metadata.

What Are The Basic Functions For Master, Msdb, Model, Tempdb And Resource System Databases?

Answer»

The master database holds information for all databases located on the SQL Server instance. As SQL Server cannot start without a functioning master database, we must administer this database with care and monitor Startup Parameters in Configuration Manager.
The MSDB database stores information regarding database backups, SQL Agent information, DTS packages, SQL Server jobs, and some replication information such as for log shipping.
The tempdb holds temporary objects such as global and local temporary tables and STORED procedures.
The model is essentially a template database USED in the creation of any new user database created in the instance.
The resource Database is a read-only database that contains all the system objects that are INCLUDED with SQL Server. SQL Server system objects, such as sys.objects, are physically persisted in the Resource database, but they logically appear in the sys schema of every database. The Resource database does not CONTAIN user data or user metadata.