search cancel

The Transaction Log for database 'DB' is full due to 'LOG_BACKUP'.

book

Article ID: 174622

calendar_today

Updated On:

Products

IT Management Suite

Issue/Introduction

When Running through a Symantec Management Platform repair through Symantec Installation Manager it fails with error "the Transaction Log for database 'DB' is full due to 'LOG_BACKUP'".

Configuration Failed

A critical error occurred:

System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Altiris.NS.Exception.AeXException: The transaction log for the database '_DB' is fill due to 'LOG_BACKUP'.---> System.Data.SqlException:

 

Cause

Transaction log in SQL are Full.

Environment

ITMS 8.x

Resolution

Try one of the 4 suggestion below to fix this issue:

  1. Under SQL Server Management Studio set the Maximum File Size under options for Altiris database to Unrestricted File Growth.
  2. Increase the Restricted File Growth (MB) size to a larger value creating space for transaction logs to grow.
  3. Shrink the log files from task. Right click Search_Service_DB, go to Tasks -> Shrink -> Shrink Files.  Select a File type of Log, then Shrink.
  4. Move the Existing Transaction log files to a different location to workaround this.

NOTE: Please make sure you have a fresh and full backup of Database before following above suggestion. Kindly follow the steps only under assistance of your DBA team.

Attachments