Probably Your database in recovery mode at this moment
Just check Event Viewer

You have to wait until your recovery complete and then drop database
Or Try Detach database When you detach thru Enterprise Manager it will ask
you if you want stop all connection to this database and then drop files



-----Original Message-----
From: Kaustubh Puranik
[mailto:mssqldba-ezmlmshield-x34254957.[Email address protected]
Sent: Wednesday, April 27, 2005 3:49 PM
To: LazyDBA Discussion
Subject: Drop database


I can not connect to one of my databases through Query Analyzer or
Enterprise Manager. When I try that it is hanging. I found that .ldf
file is 30gb and I tried to shrink the file and/or shrink the database
it was also hanging. I tried to run DBCC CHECKDATABASE but it never
complete. So finally I decided to drop the database using Query
Analyzer as I can connect to the master database. When I run the drop
command I got error saying database is in use. I checked the
sysprocesses table but there is not a single entry for this database. I
know no one else is using database right no. I do find one entry into
syslocks table... I want to drop the database and restore it from
backup... What should I do to drop this database? In this process I
restarted the server several times.



Thanks in advance...



k.





---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]


MS Sql Server LazyDBA home page