https://puresourcecode.com/dotnet/sql/how-to-truncate-log-file-in-sql-server/
How to truncate log file in SQL Server