Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register Now.

Home > Success Center > Web Help Desk (WHD) > Web Help Desk down: The transaction log for database 'WHD' is full due to LOG_BACKUP

Web Help Desk down: The transaction log for database 'WHD' is full due to LOG_BACKUP

Updated September 29, 2016

Overview

This article shows how to resolve the issue where WHD down and TRUNCATE EMAIL_DATA_OBJECT gives the following error message:

 The transaction log for database 'WHD' is full due to 'LOG_BACKUP'

Environment

  • WHD 12.2.3
  • Windows Server 2012

Cause

This occurs when EMAIL_DATA_OBJECT size increases exponentially.

Resolution

Address the database issue

  1. Change Database Recovery model from Full to Simple.
  2. Shrink log files using SQL Studio.
    1. Right click WHD Database > Tasks > Shrink > Files.
    2. Select Log in File Type field.
    3. Click on OK.
  3. 3. Truncate EMAIL_DATA_OBJECT.

 

Control the growth of EMAIL_DATA_OBJECT,

  1. Log in to the WHD Console as an Administrator
  2. Go to Setup > E-Mail > Options.
  3. Under E-Mail Options, look for Delete E-Mail History Entries After and set it to a shorter period.
  4. Save.

Note: The EMAIL_DATA_OBJECT table mainly stores data for reference, such as when an email is rejected.

 

 

Last modified
20:30, 28 Sep 2016

Tags

Classifications

Public