Problem:

Client discovers an increase in transaction log size and is running out of space on the Log file drive.


Solution:

Maintenance of the SQL server and Log files Maintenance is not handled by ClickHome but by the Client IT usually the infrastructure team. This could be a clients in-house or external IT staff. 

Database log files are different to the application logs generated by ClickHome3. Regular back up of the transaction log eliminates growth. Each time the log is backed-up, it resets the internal use of the log, and the new logs just overwrite.
What is a transaction log


When ClickHome is deployed, the database is set to full recover mode, this allows data to be restored to a specific point in time to reduce data loss. However this can lead to large transaction logs if regular backups are not performed.

 
The quickest way to recover the space used by the transaction log is to set the database recover mode from full to simple and then do a normal backup. We recommend a full database backup before changing the recovery mode. You should now be able to put it back to full recover mode and then using regular log file backups, the log size will stay under control.

Please ensure above is done in a safe way.


Maintaining proper backup routines are paramount in case of data corruption. Please read below a few articles on best practices.


Some Suggested Links on Backup methodology are below:

MSDN Overarching Backup Article: https://msdn.microsoft.com/en-us/library/ms187048.aspx
SQL Authority Blog: http://blog.sqlauthority.com/2012/12/18/sql-server-select-the-most-optimal-backup-methods-for-server/


Other Links

http://dba.stackexchange.com/questions/29829/why-does-the-transaction-log-keep-growing-or-run-out-of-space
http://www.databasejournal.com/features/mssql/importance-of-recovery-model-in-sql-server.html
http://technet.microsoft.com/en-us/library/ms190440(v=sql.105).aspx
http://www.techrepublic.com/blog/the-enterprise-cloud/help-my-sql-server-log-file-is-too-big/
http://www.sqlshack.com/10-important-sql-server-transaction-log-myths/