Basic
functions for master, msdb, model, tempdb and resource databases?
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.
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
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.
No comments:
Post a Comment