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.

53 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.

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

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!!!
แทงSicboonline

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>

Unknown 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

Unknown said...

Good article good job thanks เกมยิงปลาออนไลน์

Duke221 said...

Thank you for liking, press share
I exactly got what you mean, thanks for posting. And, I am too much happy to find this website on the world of Google
สมัคร sa gaming
sa casino online

Duke221 said...

สมัคร sa gaming
sa casino online
I am thankful to you for sharing this plethora of useful information. I found this resource utmost beneficial for me. Thanks a lot for hard work.

Duke221 said...

Good advice. Thank you for the advice.
สมัคร sa gaming
sa casino online

Comfortreview said...

Thank you for writing this blog. แทงบาคาร่า10บาท

Duke221 said...

Good advice. Thank you for the advice. เดิมพันsagaming

Unknown said...

your article is very good Can you give me some advice on my writing method เกมสล็อตออนไลน์มาแรงที่สุด

Unknown said...

your article is very good Can you give me some advice on my writing method รีวิวสล็อตออนไลน์

Comfortreview said...

Nice content. Thank you. SA Gamingทดลองเล่น

Kennocha said...

I was reading your article and wondered if you had considered creating an ebook on this subject. Your writing would sell it fast. You have a lot of writing talent.เว็บพนันSA Gaming

Kennocha said...

Thank you for liking, press share
I exactly got what you mean, thanks for posting. And, I am too much happy to find this website on the world of Google SA GAMINGเว็บไหนดี

Unknown said...

your article is very good Can you give me some advice on my writing method รีวิวเกมสล็อตมาแรง

Kennocha said...

Thanks for the blog filled with so many information. Stopping by your blog helped me to get what I was looking for. Now my task has become as easy as ABC. แทงบาคาร่าออนไลน์

Comfortreview said...

Nice advice. Thank you for this blog. แทงบาคาร่าออนไลน์

Reviewgame said...

i like this blog And I want my friends to see สล็อตค่าย joker

Kennocha said...

เล่นพนันเกมยิงปลา Thank you for liking, press share
I exactly got what you mean, thanks for posting. And, I am too much happy to find this website on the world of Google

Amando said...

The blog written is extremely impressive, with a great topic. เว็บเกมขึ้นยานเครดิตฟรี

Amando said...

Thank you for recommending a good thread. เว็บเกมขึ้นยานเครดิตฟรี

Comfortreview said...

Awesome content. Thank you. เว็บพนันบอลออนไลน์ดีที่สุด

Oki said...

your website is very amazing ! เว็บผลบอลสด And this one too. เว็บข่าวบอลวันนี้

แทงบอลสด said...

Great tips and very easy to understand. This will definitely be very useful for me when I get a chance to start my blog
สล็อตยูฟ่า777

Kennocha said...

เว็บบอลออนไลน์ I have read it, it feels good and it is very useful to me.

Cannon said...

I gained knowledge from your article, Thank youอัพเดตผลบอล ทีเด็ดฟุตบอลคืนนี้ล

Cannon said...

I feel so good with your article, Thank you.ทีเด็ดบอลวันนี้ ผลบอลเมื่อวาน

phkhnsmburn said...

That's good news, I've been following for a long time.ทรรศนะบอลคืนนี้ I am always searching online for storys that can accommodate me ทีเด็ดบอลเต็ง

tee said...

It's very knowledgeable Thank you for the comm. ทีเด็ดบอลสูง-ต่ำ ผลบอลย้อนหลัง

ball said...

ไฮไลท์ลิเวอร์พูลล่าสุดIt is extremely helpful for me.ไฮไลท์ลิเวอร์พูล

usop said...

It is tthe little changes that will make the greatest changes. Thanks a lot for sharing!
ข่าวฟุตบอลต่างประเทศ
ข่าวฟุตบอล

pup said...

ข่าวฟุตบอล I am always searching online for storys that can accommodate me ข่าวฟุตบอลต่างประเทศ

usop said...

I visited many web sites but the audio quality for audio songs existing at this website
is in fact wonderful.
ผลบอลสด
ผลบอลบนมือถือ

nuggetgoal said...

The information here will be useful to everyone. This is a very good blog. ทีเด็ดฟุตบอล ทีเด็ดบอลสเตป

pgSlot365x said...

Wohh just what I was looking for, regards for posting.

แทงบอลไทยบนมือถือ

Cannon said...

Thank you for a good articleเว็บทีเด็ดบอล
ผลบอลเมื่อคืน

Cannon said...

Let's spread good stories like this again.เว็บทีเด็ดบอล
ผลบอลเมื่อคืน

Kennocha said...

เว็บแทงบาคาร่าสดHello, I'm from Thailand. Excellent website Very useful to me
I like this website

pgSlot365x said...

Wohh just what I was looking for, regards for posting.

ทางเข้า ufabet

MaksimMB said...
This comment has been removed by the author.
LilyDarari said...

It's sound good.
พนันเสือมังกรออนไลน์

jibijujudr said...

หากจะเลือกเล่น เกมสล็อตสักเกม เราขอแนะนำเว็บ สล็อตเว็บตรงแตกง่าย ที่รวมเอาเกมสล็อตต่าง ๆ จาก ค่ายเกมสล็อตแตกง่าย แตกบ่อย

Post a Comment

Ads