Mike & Doris Manning
mikedorism at adelphia.net
Mon Apr 4 10:46:57 CDT 2005
They are still there because you unchecked "remove history". As long as you have a full backup, you can restore the databases without an LDF. It will just create one for you. Doris Manning Database Administrator Hargrove Inc. www.hargroveinc.com -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Julie Reardon-Taylor Sent: Monday, April 04, 2005 11:19 AM To: dba-SQLServer at databaseadvisors.com Subject: [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 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com