Delete the extra log file attached | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Delete the extra log file attached

Dear All, One of my team members has attcahed a extra log file to one of the datbases. How to remove this and what will be the repercussions of the same. Can anyone help me with a clear picture as to how should i go abt it. Thanks,
Hemanth Hemanth
Take a look at the ALTER DATABASE syntax in BOL or do a forum search here. This has been discussed here recently.
IMHO, there is no sense in having more than t-log ———————–

.. and you need to use DBCC SHRINKFILE with EMPTYFILE option in order to remove the log file from database. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.