Cannot drop database 'Tara' because it is being used for replicati

[bluefish]

One of our critical databases that is part of a log shipping-like set up is
corrupt. This happened while doing a full DEb restore. DB was showing status
'Loading/Suspect' for about 5 hours. However, restore job has failed, and
nothing is attempting to restore it. I am unable to get get any information
of the DB via Query Analyzer or Enterprise Manager.

I need to drop this DB and recreate it, but I am unable to do any
drop/delete operation on this DB as well.

About an hour ago, I stoped the SQL Server, and deleted the .mdf and .ldf
files from the physical location. When I start the SQL Server back up, the DB
is still visible, and I am not able to do anything with it.

When I try to drop the database I get following error.
"Cannot drop database 'Tara' because it is being used for replication." We
don't have any replicaiton set up going on at all.

IF I do sp_helpDB it gives me following message
No permission to access database 'Tara'. I am logged on as sa.

Anyone knows what is going on hear?

Thank you
BlueFish

[Geoff N. Hiten]

use master
go
exec sp_removedbreplication 'Tara'
go
drop database 'Tara'

Geoff N. Hiten
Microsoft SQL Server MVP

"bluefish" <blue...@discussions.microsoft.com> wrote in message
news:CB38AC55-B701-4CA0...@microsoft.com...