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 ———————–
–Frank
http://www.insidesql.de
———————–

.. and you need to use DBCC SHRINKFILE with EMPTYFILE option in order to remove the log file from database. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>