Sage 100

I have an issue where the KS log file is so large on the server that it has caused all the other programs like (Sage 100, Sage CRM, and Starship) to become non-operational because there is no disk space left on the server. I'm still waiting to hear back from KS support to expedite the ticket. I have stopped the KS service under windows service but it still generating the log file in SQL. Can anyone offer feedback:

Is it safe to delete the KS object_log.ldf file in SQL?

Does anyone know how to disable this program so that it will stop generating the log file?

------------------------------
Shannon Stanley
Sage 100 Consultant
Ardent Consulting LLC
704-839-6697
------------------------------

Hello Shannon,

The solution is to change the database properties from Full Recovery mode to Simple Recover mode.  Once done, shrink the database.  DO NOT delete the LDF file.

Unless SQL maintenance is configured to manage the log file, Full Recovery shouldn't be used (provides point in time restore, but seldom used and few actually know how to configure SQL jobs to manage).

Would coordinate with SQL management person to review all database configurations when able.

Hope this helps.

Andy

------------------------------
Andy Adkisson
Tennessee Software Solutions
------------------------------

Got it, thank you for your help!