What is the basic functions for master, msdb, tempdb databases?
- 2 Answers
- 16075 Views
- CSC, I also Faced
- E-Mail Answers
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
how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration
Explain syntax for viewing trigger?
Can sql servers linked to other servers?
If you want to send some data from access database to sql server database. What are different component of ssis will you use?
How to assign new column names in a view?
How do I start and stop sql server?
What is the difference between Stored Procedures and triggers?
What happens if an integer is too big for int date type?
What do you understand by integration services in sql server?
What is resource governor in sql server?
What is the difference between migration and upgradation in sql server?
Explain about Normalization?
Which is the latest version of sql server and when it is released?
What is abstracting periodical?
What are the different types of replication are there in sql server 2000?
