How to remove second log file in SQL Server
ALTER DATABASE dbname SET RECOVERY SIMPLE
GO
BACKUP LOG [dbname] WITH TRUNCATE_ONLY
GO
USE dbname
GO
DBCC SHRINKFILE (dbname_Log,0)
GO
ALTER DATABASE dbname SET RECOVERY FULL
GO
USE [dbname]
GO
DBCC SHRINKFILE (dbname_Log,0)
