Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

 

 

 

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