<john.minier@centramedia.com> wrote:

>Thanks Sue...I guess I couldnt see the forest for the trees so to
>speak. I failed to delete the log file. Again thanks for the
>guidance, Ill get a grip on this monster before its all over.
>Sue Hoegemeier wrote:
>> If you drop a database - even in Enterprise Manager, it's
>> gone and the files are gone off the system. So something
>> else is probably going on.
>> Did you check the server to see if you could actually find
>> the data and log files for the database you dropped?
>> Did you do a search on the server for the largest files?
>> Did you check the recycle bin and empty that out?
>>
>> -Sue
>>
>> On 22 Aug 2006 13:53:05 -0700, "Sabernocc"
>> <john.minier@centramedia.com> wrote:
>>
>> >Sorry for being ambiguous. My hard drive is at near max capacity. It
>> >was determined that this database is not in use nor is it needed. I
>> >deleted what should have been 90 gig worth of data, but the drive still
>> >shows the same space available. I am assuming that ,since I didnt use
>> >the drop table command and then truncate the database, SQL server is
>> >still seeing the data as being allocated to a database and, with all of
>> >the table structures deleted, there is no way to us the command line to
>> >reclaim the space allocated to the now extinct database.
>> >
>> >Perhaps I could recover the database that was deleted...help there
>> >would be great.
>> >
>> >I dont need the data from the db, so Im not sure restoring to a new
>> >location would help.
>> >
>> >I dont have any reason to believe it is a defragmentation issue on the
>> >physical drive..but it is possible.
>> >
>> >Is that any clearer?
>> >Arnie Rowland wrote:
>> >> It's not clear why you are asking help.
>> >>
>> >> To try and recover the database that was deleted?
>> >> For pointers about how to restore to a new location?
>> >> How to defrag the hard drive?
>> >>
>> >> Please give more information and be a bit more pointed with your question.
>> >>
>> >>
>> >> --
>> >> Arnie Rowland, Ph.D.
>> >> Westwood Consulting, Inc
>> >>
>> >> Most good judgment comes from experience.
>> >> Most experience comes from bad judgment.
>> >> - Anonymous
>> >>
>> >>
>> >> "Sabernocc" <john.minier@centramedia.com> wrote in message
>> >> news:1156278462.158930.53770@m73g2000cwd.googlegroups.com...
>> >> > OK...first off, its my fault, I own it, stupid mistake. Now I have to
>> >> > fix it. I inherited an SQL server and was instructed to remove a db to
>> >> > make room on the crowded hard drive. I now know how I should have done
>> >> > it...but what I did was simply right click and delete the database. I
>> >> > cant find any way to reclaim the 90+ gig that I need to free up. Any
>> >> > help would be greatly appreciated. I am using SQL server Enterprise
>> >> > manager 8.0 on a server 2003 box.
>> >> >