What is the basic functions for master, msdb, tempdb databases?
Answer Posted / 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 |
Post New Answer View All Answers
Explain what role entity and relationship play in an ER diagram.
What is the native system stored procedure to execute a command against all databases?
How many database files are there in sql server 2000?what are they?
What are the types of resultset?
How to optimize stored procedure optimization?
How to configure and test odbc dsn settings?
Tell me what is fill factor?
How to get a list all databases on the sql server?
What is molap and its advantage? : sql server analysis services, ssas
Explain primary key in sql server?
What are the differences between char and nchar in ms sql server?
What is the difference between varchar and varchar types?
Do you know what are the differences between lost updates and uncommitted dependencies?
How to handle error or exception in sql?
What is triggers and its types?