BEDB (Backup Exec Database) size and limitations causes Backup Exec to stop functioning. Unable to start BE services, open the BE console, edit or view job history, or run jobs.

Problem

BEDB (Backup Exec Database) size and limitations causes Backup Exec to stop functioning. Unable to start Backup Exec services, open the Backup Exec console, edit or view job history, or run jobs.

Error Message


Check the Windows Event Viewer for the following errors:

Event Type: Error
Event Source: MSSQL$BKUPEXEC
Event Category: (2)
Event ID: 1105
Description:
Could not allocate space for object 'DBO.JobHistoryDetailInfo' in database 'BEDB' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.

Event Type: Error
Event Source: MSSQL$BKUPEXEC
Event Category: (2)
Event ID: 1827
Description:
CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 4096 MB per database.

Event Type: Information
Event Source: Backup Exec
Event Category: (65535)
Event ID: 57345
Description:
Database Exception Context:Insert New Alert Error:-536837662: :: -2147217900:Could not allocate space for object 'DBO.Alert'.'cidx_Alert_Date' in database 'BEDB' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup. :: DB Error Set 0: native=0x451 source=Microsoft OLE DB Provider for SQL Server hr=0x80040e14 Could not allocate space for object 'DBO.Alert'.'cidx_Alert_Date' in database 'BEDB' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.

Event Type: Information
Event Source: Backup Exec
Event Category: (65535)
Event ID: 57345
Description:
Database Exception Context:Script GetBackupDetail Error:-536837662: :: -2147217900:Invalid column name 'CommonFlags'. :: DB Error Set 0: native=0xcf source=Microsoft OLE DB Provider for SQL Server hr=0x80040e14 Invalid column name 'CommonFlags'.

Cause


This error may be caused by a low or no disk space condition on the drive hosting the Backup Exec (BEDB) Database or by the (BEDB) Database being at the maximum size allowed by the Microsoft SQL instance.  This causes multiple issues such as:

  • BEServer service failing to start
  • Job hung in a "Ready; no idle devices available" status
  • BE Console fails to open
  • Errors when editing selection lists

DATABASE LIMITATIONS:
 
SQL VersionsExpressStandardEnterpriseWorkgroup
20054GBNo LimitNo LimitNo Limit
2008 R210GB524TB524TB524TB

Solution

 
1. Free up some drive space.
2. Optimize the size of the database.
3. Remove the job history and alert entries and configure Backup Exec to automatically purge the old data on a regular basis. 
 
* Backup Exec Database Maintenance can be configured to perform the tasks mentioned in step 2 and step 3. Refer to the Related Articles section for additional information.
 
NOTE: Customers experiencing this issue are encouraged to contact Symantec Technical Support if the Backup Exec BEDB database is 4GB or greater.  New Alerts and Database tasks in Backup Exec 2010 R2 give warnings when the database is approaching the SQL limitation.  
 
 
 
 
 

Terms of use for this information are found in Legal Notices.

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

Did this article save you the trouble of contacting technical support?

No
Yes

How can we make this article more helpful?

Email Address (Optional)