Cannot drop/restore or detach db

Hi ALL
There are no connections or processes running against one
database yet I can't restore over it, detach it or drop it
because it says that it is in use. How is this possible'
Thanks
JUser DB or system DB?
>--Original Message--
>Hi ALL
>There are no connections or processes running against one
>database yet I can't restore over it, detach it or drop
it
>because it says that it is in use. How is this
possible'
>Thanks
>J
>.
>|||Make sure that you don't use the db from the connection where you want to drop it.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"J" <anonymous@.discussions.microsoft.com> wrote in message
news:045f01c3aef9$12df4e20$a501280a@.phx.gbl...
> Hi ALL
> There are no connections or processes running against one
> database yet I can't restore over it, detach it or drop it
> because it says that it is in use. How is this possible'
> Thanks
> Jsql

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

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
use master
go
exec sp_removedbreplication 'Tara'
go
drop database 'Tara'
Geoff N. Hiten
Microsoft SQL Server MVP
"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
>
>
sql

cannot copy files

I copied a database using backup and restore from Sql server 2000 to Sql server 2005. I noticed the data(mdf) and log(ldf) files did not copy. when I try to do a copy and past it gives me an error: cannot copy lof: it is being used by another person or program. Close all programs and try again. Does this mean I have to stop both servers to copy between them? Please help.just to clarify, did you successfully restore the db on 2005? if so, then I assure you the mdf and ldf are there. maybe they are not where you think they should be however.

to find out where they are, do this:

use MyDatabase
exec sp_helpfile