What is the basic functions for master, msdb, tempdb databases?

Question Posted / guest

2 Answers
15423 Views
CSC, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is the basic functions for master, msdb, tempdb databases?..

Answer / dharmendra k. dixit

Master , MSDB and TempDB
these are the inbuild Database which r provided by SQL
SERVER.
All have their own functinality & responsbility like.

1. Master : Master DB is responsible for Storing all
information at system level.
2. MSDB : it is Microsoft DB, it creates a Copy of whole
Database in it
3. TempDB : it stores all the log information of Server,
it will initilize automatically wheneve Server will start,
the max. size alloted fro TempDB is 10MB.

Thanks & Regards
Dharmendra k. Dixit

Is This Answer Correct ?

16 Yes

10 No

What is the basic functions for master, msdb, tempdb databases?..

Answer / pinak

the basics function of master is "it stores all sytem level
information in it, all databases which need for user
defineed database.
msdb is microsoft database.it works just like a recorder.

tempdb is a temprary database.

Is This Answer Correct ?

8 Yes

10 No

Post New Answer