Submit a ticketCall us

Don’t fall victim to a ransomware attack
Backups are helpful, but sometimes that’s not enough to protect your business against ransomware. At our live webcast we will discuss how to protect against ransomware attacks with SolarWinds® Patch Manager and how to leverage log data to detect ransomware. Register now for our live webcast.

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