Shrink Log file in SQL

Shrink Log file in SQL

Run the below command in sql:

ALTER DATABASE DatabaseName SET RECOVERY full  
GO
ALTER DATABASE DatabaseName SET RECOVERY SIMPLE WITH NO_WAIT;
GO
USE DatabaseName 
GO
DBCC SHRINKFILE('DatabaseName _log', 0, TRUNCATEONLY)