| Author |
Topic |
|
harshal_in
Aged Yak Warrior
633 Posts |
 Posted - 2003-12-11 : 08:31:26
|
| hi,is it possible to delete any of the system database (master,msdb,tempdb or model) and still the working of sql server is not affected.thanks in advance .regards,harshal.The Judgement of the Judge is as good as the Judge. |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2003-12-11 : 09:09:14
|
| Hi Harshal!It's not a good idea to delete any of them. It's possible that the server would still run without msdb, but why would you want to remove it? It's not very large as I recall, and if you don't use any of the functionality in it, it won't grow. |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-12-11 : 20:44:21
|
| Welllllll, it's possible, just like it's possible to remove your heart, lungs, and brain and still stay alive...for about 60 seconds. |
|
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
Posted - 2003-12-11 : 20:47:03
|
Don't let Robs comment stop you.. Have a go...According to BOL it is impossible....quote:
System databases (msdb, master, model, tempdb) cannot be dropped.
DavidM"SQL-3 is an abomination.." |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-12-11 : 20:48:04
|
| Harshal, why, why, why, why would you want to do that? Do not touch master, model, msdb, or tempdb. Northwind and pubs can be deleted (these are not system databases, but you get them with each install).If you already deleted any of them, hopefully you've got a backup or at least have already started reinstalling SQL Server due to the fatal errors that you are currently getting.Tara |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-12-11 : 20:58:33
|
quote:
or at least have already started reinstalling SQL Server due to the fatal errors that you are currently getting.
Or preparing your resume  Damian |
|
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2003-12-12 : 00:21:10
|
| Thankyou everyone for all your valuable inputs.I have not deleted any of these databases,and don't even plan to try that feat.This was a question which was asked to me in a interview.I was sure about the answer but just wanted to make sure.thanks.The Judgement of the Judge is as good as the Judge. |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2003-12-12 : 01:11:04
|
| how did you answer the question? |
|
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2003-12-12 : 01:40:40
|
quote:
Originally posted by eyechart
how did you answer the question?
there is no option for deleting these databases from the em as microsoft doesn't allow it.Still if these databases are deleted,it may work if the model or msdb is deleted provided no new database is created and no jobs are configured.The Judgement of the Judge is as good as the Judge. |
|
|
|
|
system database