SQL Server Performance Forum – Threads Archive
Delete the extra log file attachedDear 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,
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.