Loading...

Knowledge Center


How to troubleshoot a full ePolicy Orchestrator database
Technical Articles ID:   KB90100
Last Modified:  5/10/2018

Environment

McAfee ePolicy Orchestrator (ePO) 5.x

Summary

The ePO database size can grow significantly over time for various reasons, such as:
  • Virus outbreaks
  • False positives
  • Update Errors
  • Upgrading
If the ePO database grows too large, ePO might become unusable or unstable until you take the appropriate actions to reduce it.

If the ePO database runs on a SQL Express instance
SQL Express has a hard-coded maximum database size of 10 GB. If you reach this limit, the database cannot grow any further, even if you have space available on the storage device that hosts it.

You can address this issue in one of the following ways:
  • Delete old events to create space in the database. See KB68961 for details.
  • Move the database to a full instance of SQL, which does not have the 10-GB limit, and allow the database to grow as required. See KB68427 for details.

If the ePO database runs on a full instance of SQL
The following are the most common causes of Database full errors:
  • The hard disk or storage device hosting the database files is full.
    Either of the following approaches address the issue:
    • Delete or move other files on the same device to make space available.
    • Move the database files to another storage device that has space available.
To learn more about moving databases, see:
  • The database has reached its defined maximum size, as set in the properties for the database.
    Either of the following approaches address the issue:
    • Delete old events to create space in the database. See KB68961 for details.
    • Increase the maximum size of the database file (or files) to allow the database to grow. 
       
  • The transaction log has run out of space.
    Address the issue as follows:
  1. Truncate the transaction log (see https://technet.microsoft.com/en-us/library/ms189085(v=sql.105).aspx for details).
  2. Use the Simple recovery model for your database. The Simple recovery model allows SQL to manage the transaction log for you, avoiding future transaction log growth.

Rate this document

Beta Translate with

Select a desired language below to translate this page.

Languages:

This article is available in the following languages:

English United States
Spanish Spain
Japanese

Glossary of Technical Terms


 Highlight Glossary Terms

Please take a moment to browse our Glossary of Technical Terms.