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.

24 comments:

Luckyslot said...

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

Unknown said...

I want to read more of your good articles. Well done.
เกมขึ้นยานค่ายไหนดี

theoceanworld said...

What an amazing article sa gaming เว็บไหนดี

Unknown said...

The article was very useful to me, Thank You. รีวิวเกมสล็อตออนไลน์

Reviewgame said...

I will share this blog it's really good เว็บพนันบอลออนไลน์ UFABET365

Amando said...

Outstanding article!
สมัครเว็บบอล

movieblog365 said...

https://glazerpromos.com/cost-effective-ways-promote-business/#comment-49821

wanon said...

Thank for share the best thing.
เดิมพันpg Slotขั้นต่ำ1บาท

jedyub said...

I like your message and think like you. :))
ผลบอล365
ทีเด็ดฟุตบอลบนมือถือ

jedyub said...
This comment has been removed by the author.
Cannon said...

I gained knowledge from your article, Thank youทีเด็ดบอลออนไลน์
ผลบอลอัพเดตล่าสุด

jedyub said...

I like your message and think like you. :p
เว็บผลบอล
ทีเด็ดฟุตบอล

jedyub said...

I like your message and think like you. :)
ผลบอลสด365
ทีเด็ดฟุตบอลวันนี้

tungkuay said...

I want a way to contact my friends.
เกมโชว์ Evolution365

pgSlot365x said...

I will bookmark your site and take the feeds additionally..... Evo casinoเครดิตฟรี

pgSlot365x said...

I will bookmark your site and take the feeds additionally..... evolutionแบล็คแจ็ค10บ.

pgSlot365x said...

I will bookmark your site and take the feeds additionally..... ซื้อสปินเกมสล็อต

wanon said...

I will bookmark your site and take the feeds additionally..... ซื้อหมุนฟรีขั้นต่ำ1บาท

pgSlot365x said...

Find a website about travel around the world.....
พีจีสล็อตทุนน้อยไม่มีขั้นต่ำ

pgSlot365x said...

We provide best services to all class of clients เว็บสล็อตแจกโบนัส

tungkuay said...

We provide best services to all class of clients
ดูบอลสด HD

tungkuay said...

Wohh just what I was looking for, regards for posting. ลิ้งดูบอลสด

pgSlot365x said...

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


เว็บดูบอล

Anonymous said...

hey this is a good article very useful
สมัครสมาชิกufacasino
บาคาร่าออนไลน์
เล่นบาคาร่าขั้นต่ำ 10 บาท

Post a Comment

Ads