[dba-SQLServer] Take Database Offline and Delete

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






More information about the dba-SQLServer mailing list