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

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

Reason: 
You will receive this error if you are using Microsoft SQL back end for Applications Manager and if the transaction log for Applications Manager database or tempdb becomes full. If the log fills up, Applications Manager can only read and show data but cannot insert or update data being collected. User action is required to make log space available.

Solution: You can try the following steps to fix this problem:
  1. Shutdown Applications Manager.
  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 Applications Manager back end database. For ex: BACKUP LOG AMDB TO DISK = 'd:\AMDB.bak'
  5. Change the Applications Manager back end database recovery mode to SIMPLE. For ex: ALTER DATABASE AMDB SET RECOVERY SIMPLE;
  6. Execute the DBCC SHRINKDATABASE for the back end database. For ex: DBCC SHRINKDATABASE (AMDB);
  7. For enabling future database backups, change the database recovery mode to FULL. For ex: ALTER DATABASE AMDB SET RECOVERY FULL;
  8. Start Applications Manager.

Note : If you do not have sufficient disk space or log file allocated space the problem may occur again after some time. It is recommended that you allocate sufficient disk / log file space for the SQL Database back end. For disk space requirement refer the following System requirements link: https://www.manageengine.com/products/applications_manager/help/system-requirements.html
        New to M365 Manager Plus?
        New to M365 Manager Plus?
          New to RecoveryManager Plus?
          New to RecoveryManager Plus?
            New to Exchange Reporter Plus?
            New to Exchange Reporter Plus?
              New to SharePoint Manager Plus?
              New to SharePoint Manager Plus?
                  See all integrations
                  New to ADManager Plus?
                  See all integrations
                  New to ADManager Plus?

                    New to ADSelfService Plus?

                    Start your free trial
                    Start your free trial

                      • Related Articles

                      • Applications Manager default tomcat is down

                        If your Tomcat Monitor is down, it could probably be due to changes in Hostname/IP address of the machine in which Applications Manager is installed. You can verify the same using the steps given below: Navigate to ...

                      • AppManager disk is full - I want to clear some space

                        Increased Applications Manager database utilization could have increased the Applications Manager Disk size. To clear some space, follow the steps below: 1. In the <AppManager_Home>\working\heapdump directory, check if any old files are present and ...

                      • Can I view the trace of a web transaction that consumes more response time?

                        Please make sure that "Enable transaction tracing" option is enabled in Agent Configuration. Set the threshold for transaction tracing in "Transaction trace threshold" option (in seconds). Traces will be generated for any transactions that takes ...

                      • Where can I see the .NET agent logs?

                        The .NET agent logs can be found only in the common application folder (Usually under C:\ProgramData\ from Vista onwards and C:\Documents and Settings\All Users\Application Data\ for Windows Server 2003. This is a hidden folder) Check the below ...

                      • Folder path to view the Node.js agent logs

                        By default, the logs generated by the Node.js agent are stored in the apminsightdata folder, which resides in your application's current working directory. The log files can be found at: <app-path>\apminsightdata\logs If you would like to customize ...

                        Related Products