[dba-SQLServer] Take Database Offline and Delete

Hi,

I have two "test" databases, and two old databases that I would like to 
store on tape.  These log files have grown out of control, and I need to get 
the mdf and ldf files off of the system.

Tried shrinking through Enterprise Manager, and it didn't do a thing.  
Backed up three of the transactions logs, and they didnt' shrink.  Finally, 
after backing up the databases to tape, I went into Enterprise Manager, took 
the databases offline, then deleted the databases.

However, all of the ldf and mdf files still show in my sql server data file? 
  How is this possible?
They do not show up in Enterprise Manager-when deleting the databases, I 
unchecked "remove history...........".  Could that be the reason?

Is it now safe to go into the sql server folder and just delete these files?

Only three of my transaction logs backed up.  If I have a "full" backup of 
the databases mdf file, can I restore the database without the ldf file?

This is so frustrating!



Julie Reardon-Taylor
PRO-SOFT OF NY, INC.
44 Public Square Suite #5
Watertown, NY 13601
(315) 785-0319
www.pro-soft.net