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 |
What do you understand by mirroring and mention the advantages of the mirroring?
Can we call future method from trigger?
Explain intellisense for query editing
How do you set a trace flag in sql server?
wt is mean by acid property? i know it is atomocity,consistency,isolation and durabulaty but wt is these mean and wt actions it's perform
What is the difference between insensitive and scroll cursor?
Explain features of analysis services?
How would you retrieve Unique rows from table without using UNIQUE and DISTINCT keyword?
what is meant by sql injection with example and one more question how to catch the errors in sqlserver
Can an automatic recovery be initiated by a user?
what is the different types of backups available in sql server? : Sql server database administration
How to use copy and concatenate commands in SQL?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)