What is the basic functions for master, msdb, tempdb databases?
Answers were Sorted based on User's Feedback
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 |
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 |
how many bits ip address consist of? : Sql server database administration
What is the meaning of sql server?
What are cursors?
Can you leave a union at any time?
Explain an incremental backup?
What is tablesample?
Explain features of analysis services?
what is a default tcp/ip socket assigned for sql server? : Sql server database administration
What is clustered index
can you any body tell me while running BCP Out in instance in sql server 2000 is getting error. Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.?
can a database be shrunk to 0 bytes, if not, why? : Sql server administration
Do you know what are the restrictions applicable while creating views? : SQL Server Architecture