Saturday, 31 October 2015

Basic functions of Master, MSDB, Model and Tempdb databases in SQL Server

After a long time, I did open SQL Server Management Studio and connected to a database. Just remembered the basis which I read when I didn't my career.

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


Msdb
This database stores information regarding database backups, SQL Agent information, DTS packages, SQL Server jobs, and some replication information such as for log shipping.


Model
This database is essentially a template database used in the creation of any new user database created in the instance.


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


Hope this helps.
 
--
Cheers,

Gopinath

1 comment:

  1. Really good information to show through this blog. I really appreciate you for all the valuable information that you are providing us through your blog. SQL server dba Online Course

    ReplyDelete