What is the basic functions for master, msdb, model, tempdb databases? | SansSQL

Thursday, June 12, 2008

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

The Master 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.
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.

4 comments:

dwarkesh said...

hi sandesh,
i m dwarkesh...i develope one project in asp.net with c# and i need to create database for contact us form which used 4 text box and 1 button .

but i m new to sql server so i don't know how to whole process work .
plz give me info' to this mail id d4deks@gmail.com

Sandesh S said...

Hi Dwarkesh,
To create a database in sql 2000, follow the below steps,
1.Go to all programs
2.Microsoft SQL server
3.Enterprise Manager
4.Expand "Microsoft SQL Servers"
5.Expand "SQL Server Group"
6.Expand "(local)" (if it is the default instance in that server)
7.Expand "Databases"
8.Right-click on the databases and select "New Database"
9.Give the name of the database
10. Click OK
11.check for the newly created database in the databases folder.

narayana p said...

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

mary Brown said...

A IEEE project Domain is an interrelated arrangement of exercises, having a positive beginning and end point and bringing about an interesting result in Engineering Colleges for a particular asset assignment working under a triple limitation - time, cost and execution. Final Year Project Domains for CSE In Engineering Colleges, final year IEEE Project DOmains Management requires the utilization of abilities and information to arrange, plan, plan, direct, control, screen, and assess a final year project domains for cse. The utilization of Project Management to accomplish authoritative objectives has expanded quickly and many engineering colleges have reacted with final year IEEE projects Project Centers in Chennai for CSE to help students in learning these remarkable abilities in their respective domains.


Spring Framework has already made serious inroads as an integrated technology stack for building user-facing applications. Spring Framework Corporate TRaining the authors explore the idea of using Java in Big Data platforms.
Specifically, Spring Framework provides various tasks are geared around preparing data for further analysis and visualization. Spring Training in Chennai

Post a Comment

Ads