transaction log deletion

[fuller772]

I have been trying to get rid of a 2nd transaction log that is not needed on a database. I have tried dettaching the db > deleting out the ldf file in windows explorer > and then reattaching the db.

The tran log I deleted shows up on the reattach with a red x and fails to reattach the db. Am I doing something wrong? or is there an easier way of deleting a tran log?

Any help is appreciated.

 

[mrdenny]

You'll need to tell the SQL Server to empty the file and then delete the file with the alter database command.

Look at the dbcc shrinkfile and alter database commands in Books OnLine.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)