Backup Exec SQL Express Database Full
We are running Backup Exec 2012 fully patched, and we back up about 20 servers to a single media server using deduplication. The media server is standalone using all defaults and SQL 2005 Express. After we upgraded from 2010 to 2012, there seemed to be a large amount of older historical data (Job History, Backup Sets, etc.) that never seemed to get purged out over time. I finally took it upon myself to begin manually deleting the very old backup sets through the management GUI. This worked fine, for a while. Then, unbeknownst to me, the SQL database went from about 30MB to 4GB in a matter of a few weeks. The table that filled up appears to be the dbo.BELog table, although there may be others that have grown as well. I am assuming that this is due to Audit Log settings.
So, anyway, I thought I would simply Export my Configuration Settings and create a new database file, but NO, the Export function has been removed from the Backup Exec Utility, at least for non-CASO. I have tried to clear the audit log but attempting to access the log or log configuration produces an “unknown exception” error, probably because of too much data. So now I am trying to figure out how to purge data from the dbo.BELog table but not being a SQL guy, I’m having no success. Installing full SQL is not really an option and I would rather not create a new database. Any help you can provide would be greatly appreciated. A screen shot of the SQL table properties is attached. Thanks. Randy