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.

6 comments:

Anonymous 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 Segu 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.

latesttechnologyblogs 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

tike mik said...

One more disadvantages start with the trip to the casino. Depending on where you live, you might have to drive for several hours, or fly, just to get there., on the other hand, When you choose an online casino, you remain in control.

sbobet88 mobile

tike mik said...

Under these circumstances, coaches and teachers (and parents if possible) have a very important responsibility to ensure that our athletes are well prepared for competition. dart bord

Post a Comment

Ads