Deleting or truncating log files
Deleting or truncating log files prevents them from becoming too large and possibly running up against a system limit that prevents from functioning correctly. Recommendations are as follows:
▪Delete or truncate the log files for the mrUserData and mrInterviewData databases as part of your regular system maintenance plan, as there is always a lot of activity in this database and the log file grows at a rapid rate.
▪When you back up a database, truncate or delete the log file that uses for recording messages related to that database.
Refer to your documentation for information on how to delete or truncate SQL log files.
See