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

                    • Mail Server Monitor - Troubleshooting

                      Common Mail Server Monitor Errors and Troubleshooting Guide 1. Unknown Host Error Description: This error occurs when the mail client cannot resolve the hostname of the mail server to an IP address. The issue typically arises from DNS resolution ...

                    • Transaction Count Mismatch Between APM Insight and applications

                      Transaction counts are crucial for understanding application performance. However, discrepancies between APM Insight-reported and application-reported counts can cause confusion. This article explores common causes and solutions for these mismatches, ...

                    • 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 ...

                    • Folder path to view the .NET Core agent logs

                      The logs of the .NET Core agent can be found at the destination that was configured during the agent installation. E.g ./InstallAgent.ps1 -Destination "G:\.NET_Core_Agent" -InstallType "local" -LicenseKey ...

                    • 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 ...

                      Related Products