If I Delete all System databases?

Question

Hi Everyone  I want to knowIf the system databases (individual) what will happen? If i execute any querieswill they run or get any errors? if delete modelmaster database what will happen? If it does n't happen any pblm to sql then what is the advantage of them? Please make me clear on this...... Thanks mahesh

Prabhu Raja · Answer

i suggest you to execute your query's like this. Use DatabaseName --Database name for the following query . It will not hurt your other databases on any way Go Delete * from table where tableid = 1 For more reference : Click Here

Pravin More · Answer

Hi maheswar tempdb is Used as a temporary work space for temporary tables created by user sand lots of other things....... and it get cleaned when sql server log out.....so server will not up when tempdb is crasheddroped or moved to another loaction n not available.............. msdb is used by SQL Server Agent for scheduling alerts database mails etc....if its damaged or droped then any scheduling information that is used by SQL Server Agent is lost ....so it needs to restore . Thanks Pravin.

maheswar reddy · Answer

Thanks for your reply.But In case of tempdbmsdb what will happen.

Pravin More · Answer

Hi maheshwar Master database is system database and it contains information about running server's configuration. When SQL Server is installed it usually creates master model msdb system database by default. therefore Without Master database SQL Server can not be started. If Master database is corrupted then somethimes it can not start SQL Server at all and it can not be restored. SQL Server should be rebuild using command prompt and restored from latest backup once again. thats the master database.........hope this info help you. Thanx Pravin