Well i have gone through the articles mentioned above. Currently there is no transaction back up. database is in full recovery.

Will it be useful if we run the below query when there is no transaction active?

USE DBNAME;

GO

-- Truncate the log by changing the database recovery model to SIMPLE.

ALTER DATABASE DBNAME

SET RECOVERY SIMPLE;

GO

-- Shrink the truncated log file to 1 MB.

DBCC SHRINKFILE (DBNAME_Log, 1);

GO

-- Reset the database recovery model.

ALTER DATABASE DBNAME

SET RECOVERY FULL;

GO