Delete Database 1

[SnoopFrogg]

This is probably a simple question:

How do I delete a database within SQL Server 2000 SP3? I have a database I no longer need but I can only find the option to delete its registration within Enterprise Manager.

Thanks in advance.

[purple]
SnoopFrogg
MCSE - Windows Server 2003
[/purple]

 

[gmmastros]

Take a look at the menu you get when you right click on the database (from within enterprise manager).

Be warned, that unless you have a backup of this database, it will be gone forever.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[ptheriault]

From Query Analyzer you can also issue a drop database command.

drop database dbname

But like George said....

Make sure you have a backup.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[SnoopFrogg]

I used the wrong terminology.

I want to permanently delete a server registration from Enterprise Manager. I deleted a registration (i.e., servername\database) but, when I go to add a new SQL Server registration, the same servername\database combination appears.

Again, this is probably extremely simple...

[purple]
SnoopFrogg
MCSE - Windows Server 2003
[/purple]

 

[ptheriault]

So when you right click in EM and select add new Server Registration you see the server you removed from EM in you list? That is by default. When you use the Wizard EM will populate your drop down with sql servers on you domain. The only way to get rid of it is to shut down the server or un-install sql.

- Paul
- If at first you don't succeed, find out if the loser gets anything.