Interested to Buy Any Domain ? << Click Here >> for more details...
What is the basic functions for master, msdb, tempdb databases?
- 2 Answers
- 17250 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
You want to implement the one-to-many relationship while designing tables. How would you do it?
What is a rollup clause?
What is sql collation?
Why use “in” clause in sql server?
How can we delete a table in sql server?
Define ACID properties in a Database?
How to throw custom exception in Stored Procedure?
How do I delete a sql server database?
Do you know what is sql service broker?
What is a partition function in sql server?
Explain steps of normalization?
What is read uncmmited?
What is merge replication?
What are the advantages of using stored procedures in sql server?
What is mssql?
