The limit for transaction log file set on MSSQL databases is 1 GB.

However, it may happen that transaction log becomes too large because of abnormal activity and website application returns The transaction log for database '***' is full error.

To empty the transaction log and make the MSSQL database working properly please create a database backup via the HostPilot > MSSQL Server > Databases > click on database name > specify the name for backup and hit Backup button.