Two Log Files

[Ed75]

I recently inherited a database which I am in the process of cleaning up.

The database currently has two transaction logs, one to the same drive as the data and one pointed to the root of the C:\ drive.

It looks like the one on the C:\ drive was added later for some reason.

Is it possible to get rid of the second log file and if so how?

Thanks,

 

[mrdenny]

You should be able to empty the file and the drop the file.

dbcc shrinkfile (LogFileName, EMPTYFILE)
go
alter database DatabaseName
remove file LogFileName
go

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

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

http://www.mrdenny.com