Backup Exec 2012 Database Maintenance fails on Audit Logs, BEDB.DAT file may grow to 4GB in size.

Article:TECH201551  |  Created: 2013-01-10  |  Updated: 2014-10-22  |  Article URL http://www.symantec.com/docs/TECH201551
Article Type
Technical Solution

Product(s)

Issue



When the Backup Exec Database Maintenance occurs at (4 AM) and alert is generated that the maintenance has failed.   The Database Maintenance grooms job history, alerts, audit log information, and other items out of the Backup Exec database according to the setting under "Configuration and Settings - Backup Exec Settings - Database Maintenance".  

NOTE: Additionally, with the Backup Exec Database growing to 4GB in size,  no jobs can be executed or created. 

 


Error



Backup Exec alert

Database Maintenance Failure
(Server: "SERVERNAME") (Job: "Database Maintenance") Summary of database maintenance activity:

* Performed database consistency check for BEDB database
* Saved contents of BEDB database
* Optimized BEDB database size from 2500.38 MB to 2167.06 MB
* Deleted expired data for BEDB database:
     0 empty legacy backup-to-disk folders were deleted
     0 expired reports were deleted
     1216 expired job histories were deleted
     229 expired alert histories were deleted
     0 expired job logs were deleted

Maintenance has failed: -536837662, -536837662: :: -2147217871:Query timeout expired

Application Log

Log Name:      Application
Source:        Backup Exec
Event ID:      57348
Task Category: None
Level:         Error
Keywords:      Classic
Description:
Backup Exec Alert: Database Maintenance Failure
(Server: "HONSHU") (Job: "Database Maintenance") Summary of database maintenance activity:

* Performed database consistency check for BEDB database
* Saved contents of BEDB database
* Optimized BEDB database size from 4610.38 MB to 2167.06 MB
* Deleted expired data for BEDB database:
     0 empty legacy backup-to-disk folders were deleted
     0 expired reports were deleted
     1216 expired job histories were deleted
     229 expired alert histories were deleted
     0 expired job logs were deleted

Maintenance has failed: -536837662, -536837662: :: -2147217871:Query timeout expired
Total elapsed time: 00:05:55


Log Name:      Application
Source:        Backup Exec
Event ID:      57345
Task Category: (65535)
Level:         Information
Keywords:      Classic
Description:
Database Exception Context:Age/Purge Audit Log Error:-536837662: :: -2147217871:Query timeout expired :: DB Error Set 0: native=0xffffffff source=Microsoft OLE DB Provider for SQL Server hr=0x80040e31 Query timeout expired


Log Name:      Application
Source:        Backup Exec
Event ID:      57345
Task Category: (65535)
Level:         Information
Keywords:      Classic
Description:
Current DbTimeoutValue=30


Log Name:      Application
Source:        Backup Exec
Event ID:      57345
Task Category: (65535)
Level:         Information
Keywords:      Classic
Description:
Database Exception Context:m_QueryTimeoutInSeconds=30 sql=SELECT [ParentID],[ObjectID],[OperationID],[TimeStamp],[UserName],[Message]  FROM  [DBO].[BELog] a1  WHERE [TimeStamp]<=? Error:-536837662: :: -2147217871:Query timeout expired :: DB Error Set 0: native=0xffffffff source=Microsoft OLE DB Provider for SQL Server hr=0x80040e31 Query timeout expired 


Environment



Backup Exec 2012

 

 


Cause



Excessive audit log entries. 


Solution



A hotfix is now available for this issue in the current version(s) of the product(s) mentioned in this article. Refer to the Hotfix link under Related Documents at the end of this article to obtain the hotfix needed to resolve the issue.

Backup Exec 2012 Rev 1798 Service Pack 3 (TECH205351).

 

NOTE: The above Service Pack prevents the issue once installed.

If the Backup Exe database is 4GB in size or the Database Maintenance is failing pre Service Pack installation please perform the following Workaround:

 

 

Workaround: Truncate the Audit Log table Follow the steps below to perform an audit log truncation. 

  1. Launch the Backup Exec Administration Console and click the Backup Exec button, select Configuration and Settings, and then select Audit Log.
     
  2. In the Select category to view field, select All.
     
  3. Click Clear Category Log.
     
  4. Launch the BEUtility (default location: C:\Program Files\Symantec\Backup Exec\BEUtility.exe)
     
  5. Expand Known Computers and then select All Backup Exec Servers.
     
  6. In the right window pane, right-click the Backup Exec media server, and then click Compact Database.
     
  7. The Operation Progress dialog box will appear, indicating the process of compacting the database.
     
  8. On completion, click Close.
     
  9. Close BEUtility.

     

 


Supplemental Materials

SourceETrack
Value3047529
Description

Backup Exec 2012 Database Maintenance fails on Audit Log table.




Article URL http://www.symantec.com/docs/TECH201551


Terms of use for this information are found in Legal Notices