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?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Abhishek JaiswalPosted Jun 27, 2014, 7:22 AM
have a look at this link
https://sites.google.com/site/akshatsharma80/home/sql-server/basic_functions_master_msdb_model_tempdb
:)
Anupam SinghPosted Jun 13, 2014, 2:14 AM
model ,master,msdb 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