top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration

Facebook Login
Site Registration

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

+1 vote
What are the basic functions for master, msdb, model, tempdb databases?
posted Nov 22, 2014 by Vinitha

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

2 Answers

0 votes
Best answer

Master database is used to store information of all the databases on the SQL server. The server cannot start if the database is not configured properly.

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 is used to store 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.

answer Nov 22, 2014 by Vrije Mani Upadhyay
0 votes

• The Master database contains catalog and data for all databases of the SQL Server instance and it holds the engine together. Because SQL Server cannot start if the master database is not working.
• The msdb database contains data of database backups, SQL Agent, DTS packages, SQL Server jobs, and log shipping.
• The tempdb contains temporary objects like global and local temporary tables and stored procedures.
• The model is a template database which is used for creating a new user database.

answer Nov 22, 2014 by Manikandan J
Similar Questions
0 votes

I have scripted a PHP login form to works well. I thought of the sign up part and realised that there may be individual or group/ company registration.I did 2 different forms for each category of registration.My challenge now is how to integrate the two.I want to make the login form be able to serve the two database because it is a single site for both individual and corporate members.

+1 vote

For a project I use git with a dev branch. If it get's stable, it is merged to master. Now I have to maintain different versions of the software. (for example v1.0 and v2.0)

What is the best way to handle a hotfix for the old version v1.0? I know, I can create a hotfix branch. But what to do after that? Should I maintain this hotfix branch forever or is it better to merge the hotfix somehow into the master branch?

Currently I have to integrate a hotfix for v1.0. It's about a feature, which was removed in v2.0. So I think it's not a good idea to merge it back to master. But is it really a good idea to maintain a long running branch for every version?

Contact Us
+91 9880187415
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Karnataka INDIA.