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.


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

Huongkvb said...

Aivivu chuyên vé máy bay, tham khảo

vé máy bay đi Mỹ

vé máy bay từ los angeles về việt nam

giá vé máy bay từ canada về Việt Nam

nhật về việt nam

mua ve may bay tu han quoc ve viet nam

Vé máy bay từ Đài Loan về VN

chi phí vé máy bay cho chuyên gia nước ngoài

Tam Richard said...

Thank you for helping people get the information they need. Great stuff as usual. Keep up the great work!!!

charissa said...

It's the most exciting article. i thank you for sharing รีวิวเกมสล็อตReel love

charissa said...

"Is the best article I appreciate you sharing this much useful information.
รีวิวRed Tiger

Luckyslot said...

Thanks for another great article. ทางเข้าเล่นสล็อตออนไลน์

Luckyslot said...

This is a good article. I read it many times คาสิโนออนไลน์ Ufa800

charissa said...

"Thank you for sharing your knowledge. and new things to study รีวิวค่ายสล็อต
Red Tiger"

charissa said...

well written article that is easy to understand. <a href=" https://ppanther581701.wixsite.com/slot2online/%E0%B8%A7-%E0%B8%98-%E0%B9%80%E0%B8%AD%E0%B8%B2%E0%B8%8A%E0%B8%99%E0%B8%B0%E0%B9%80%E0%B8%81%E0%B8%A1%E0%B8%A2-%E0%B8%87%E0%B8%9B%E0%B8%A5%E0%B8%B2%E0%B9%81%E0%B8%9A%E0%B8%9A%E0%B9%80%E0%B8%8B-%E0%B8%A2%E0%B8%99 >วิธีเล่นเกมยิงปลา</a>

Long Night said...

I want to read more of your good articles. Well done.

gaco88 home said...

main di sini aja Gaco88

game paling gacor Gaco88

saya mengajak anda di Gaco88

melakukan Login di Gaco88

jangan lupa online di Gaco88

Post a Comment