The Transaction Log for database 'DB' is full due to 'LOG_BACKUP'.
Last Updated May 02, 2019
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'".
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:
Transaction log in SQL are Full.
Try one of the 4 suggestion below to fix this issue:
Under SQL Server Management Studio set the Maximum File Size under options for Altiris database to Unrestricted File Growth.
Increase the Restricted File Growth (MB) size to a larger value creating space for transaction logs to grow.
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.
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.
Subscribing will provide email updates when this Article is updated. Login is required to Subscribe