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:

NOTE: Backup Exec 22 and greater use a 64bit SQL instance name of (BKUPEXEC64). 

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

Solution