What should I do if I received error mail saying transaction logs full ?

What should I do if I received error mail saying transaction logs full ?

You will receive this error if you are using Microsoft SQL backend for SQLDBManager Plus and if the transaction log for SQLDBManager Plus or tempdb becomes full. If the log fills up SQLDBManager Plus can only be read and show data but cannot insert or update data being collected. User action is required to make log space available. 

You can try the following steps to fix this problem :

1. Shutdown SQLDBManager Plus
   
2. If you have sufficient disk space, Increase the size of log file or Add another log file to database
3. If you do not have sufficient disk space, Move the log file to a disk drive with sufficient space or Free disk space so that the log can automatically grow
4. Take a backup of the transaction logs of the SQLDBManager Plus backend database. For ex: BACKUP LOG SQLDBM TO DISK = 'd:\SQLDBM.bak'
   
5. Change the SQLDBManager Plus backend database recovery mode to SIMPLE. For ex: ALTER DATABASE SQLDBM SET RECOVERY SIMPLE;
   
6. Execute the DBCC SHRINKDATABASE for the backend database. For ex: DBCC SHRINKDATABASE (SQLDBM);
7. For enabling future database backups, Change the database recovery mode to FULL. For ex: ALTER DATABASE SQLDBM SET RECOVERY FULL;
8. Start SQLDBManager Plus
   

Note : If you do not have sufficient disk space or log file allocated space the problem reoccur again after some time. Its recommended that you allocate sufficient disk / log file space for the SQL Server backend. For disk space requirement refer the following System Requirements link : https://www.manageengine.com/products/applications_manager/sql/help/installation/system-requirements.html