What are the basic functions for master, msdb, model, tempdb and resource databases?

Posted by

To view Verified answers click on the button below.

What are the basic functions for master, msdb, model, tempdb and resource
databases?

1. The master database holds information for all databases located on the SQL Server
instance and is theglue that holds the engine together. Because SQL Server cannot
start without a functioning masterdatabase, you must administer this database with
care.

2. 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.

3. The tempdb holds temporary objects such as global and local temporary tables and
stored procedures.

4. The model is essentially a template database used in the creation of any new user
database created in the instance.

5. The resoure 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.