eMO database log file is full !!! here Solution

eMO Database Log Up normally grown. How to clear it

In Most of the offices after upgrading into Meghdoot v7.9.3 eMO database log files getting increased upnormally. Even we clear/shrink the database it will be increased automatically.

Follow the below instruction

• Take eMO database backup.
• Download and Execute the attached solution using script tool 
• Run the below query in SQL query analyzer, the issue will be solved. 

USE eMO
GO
ALTER DATABASE eMO SET RECOVERY simple
GO
DBCC SHRINKFILE (eMO_log , 1)
Go
ALTER DATABASE eMO SET RECOVERY Full

Download 

Note: Apply the above solution with SA Concerned.