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.

23 comments:

Luckyslot said...

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

Luckyslot said...

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

Long Night said...

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

theoceanworld said...

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

Clear sky 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!
สมัครเว็บบอล

phkhnsmburn said...

Your website is very helpful to me.สมัครแทงบอลออนไลน์ขั้นต่ำ 100 I am always searching online for storys that can accommodate me แทงบอลออนไลน์ฝากถอนไม่มีขั้นต่ำ

movieblog365 said...

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

movieblog365 said...

Thanks for the good information. and is very useful
รีวิวหนัง
วิจารณ์หนัง

phkhnsmburn said...

Your website is very helpful to me.เทนฮาคหวังเซนเดอยอง I am always searching online for storys that can accommodate me ประวัติ อันเดรส อิเนียสตา

pup said...

ทรรศนะฟุตบอลน่าสนใจ I am always searching online for storys that can accommodate me ทีเด็ดบอลสเต็ป5

wanon said...

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

jedyub said...

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

nuggetgoal said...

This is awesome It's a new knowledge that I have come to know. It’s a very good article. ผลบอลสด ผลบอลรอบโลก

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
ทีเด็ดฟุตบอลวันนี้

wanon said...

This is a great web site, Good sparkling user interface and, very informative blogs. thanks. You may check our website also สล็อตเว็บตรง 365ขั้นต่ำ1บาท

sk said...

Good article, there are many special things to find. This article will help you get rich

เล่นเกมโชว์อีโวคาสิโน

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เครดิตฟรี

Post a Comment

Ads