Master Database

Question

Hello Sir... What is the role of model master msdb  temdb in sqlserver. If you delete all database in system and work with our database(like create database raj) then can i do work in sqlserver yes or not?

Abhishek Jaiswal · Answer

heyy! have a look at this link https://sites.google.com/site/akshatsharma80/home/sql-server/basic_functions_master_msdb_model_tempdb :)

Anupam Singh · Answer

Hi Davin model mastermsdb and tempdb are default databases in SQLserver and they store special SQL server settings. ex. msdb have mailing configuration master database store credentials .. tempdb is responsible while working with transactions.. and many more. If you will delete any of them it might create prob lem  but if you will delete master you cant even acess SQL server. In C# corner it has already been answered before: you can refer this thread for more info : http://www.c-sharpcorner.com/Forums/Thread/175035/use-of-master-msdb-model-tempdb-and-resource-databases.aspx