What is the basic functions for master, msdb, tempdb databases? [Resolved]

Posted by Amatya under Sql Server on 3/17/2016 | Points: 10 | Views : 390 | Status : [Member] | Replies : 3
What is the basic functions for master, msdb, tempdb databases?

Feel free to share informations 9731764134
mail Id ' adityagupta200@gmail.com
Thanks



Responses

Posted by: Rajnilari2015 on: 3/17/2016 [Member] [Microsoft_MVP] [MVP] Platinum | Points: 50

Up
0
Down

Resolved
@Amatya Sir,

master - contains the database system catalogs and data particular to each database.

msdb - contains the data for the SQL Server Agent (jobs, alerts and replication).

tempdb - database used for storing temporary data and for sort operations.

More info: https://www.mssqltips.com/sqlservertip/1420/sql-server-system-databases/

Hope that helps

--
Thanks & Regards,
RNA Team

Amatya, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Amatya on: 3/17/2016 [Member] Silver | Points: 25

Up
0
Down
Nice.. n thanks bhai.. Link was useful




Feel free to share informations 9731764134
mail Id ' adityagupta200@gmail.com
Thanks

Amatya, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Rajnilari2015 on: 3/17/2016 [Member] [Microsoft_MVP] [MVP] Platinum | Points: 25

Up
0
Down
@Amatya Sir,
In that case please accept the answer

--
Thanks & Regards,
RNA Team

Amatya, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response