Interviewer - Server > Administration and maintenance > Databases > Maintaining databases > Deleting or truncating SQL log files
 
Deleting or truncating SQL log files
Deleting or truncating log files prevents them from becoming too large and possibly running up against a system limit that prevents UNICOM Intelligence Interviewer 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 UNICOM Intelligence Interviewer uses for recording messages related to that database.
For information on how to delete or truncate SQL log files, see the SQL Server documentation.
See also
Maintaining databases