Multiple Log Files Detected

Database log files are always written to sequentially, so there's no performance benefit to be gained by having more than one log file per database.

Suggested Action

💡 Select 'Suggested Script' for an automatically generated script.

Remove the extra log files if they're no longer required or used.

How to drop a secondary log file in SQL Server

ALTER DATABASE [WhippetWorks] REMOVE FILE [WhippetWorks_log_2]

Further Reading

​Transaction Log Physical Architecture | Microsoft Docs