"bluefish" <bluefish@discussions.microsoft.com> wrote in message
news:CB38AC55-B701-4CA0-88A1-3A2706D8933B@microsoft.com...
> 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
>
>
>