If I Delete all System databases?

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

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 crashed,droped 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.

Thanks,

       for your reply.But In case of tempdb,msdb what will happen.

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