Overview

The following error message is displayed in the GFI EventsManager Operation History Pane:
Primary Filegroup Full

This article provides a resolution on how to fix the issue described above.

Environment 

• EventsManager 2011
• EventsManager 2010
• EventsManager 8
• All Supported Environments

Root Cause

This error message is displayed when the GFI EventsManager database backend has a size limitation configured on the database and is unable to store any further data within the database.

Resolution

Perform the following solution depending on which version of Microsoft SQL Server is being used.

For Microsoft SQL Server:

1. Open Microsoft SQL Server Management Studio.
2. Connect to the database server hosting the GFI EventsManager database.
3. Expand the Databases node.
4. Right-click on the GFI EventsManager database and select Properties.
5. Click on the Files node in the left pane.
6. Click on the '...' button for the Data file type under Autogrowth.
7. Under the Maximum File Size section, check Unrestricted File Growth.
   Note: Ensure there is sufficient disk space on the drive where the GFI EventsManager database is stored.

For Microsoft SQL Server Express:

Microsoft SQL Server Express (versions previous to SQL 2008 R2 Express) has a maximum database file size of 4GB. Once the database reaches 4GB in size, no further data can be stored into this database. One will need to determine if the database has reached the maximum file size or a growth restriction has been configured on the database. This can be done by performing the following procedure:

Check if the maximum file size has been reached:

1. Open Microsoft SQL Server Management Studio Express.
2. Connect to the database server hosting the GFI EventsManager database.
3. Expand the Databases node.
4. Right-click on the GFI EventsManager database and select Properties.
5. Click on the General node in the left pane.
6. Under the Database section, check the size of the database. If the 4GB limit has been reached, a new database needs to be created as described below. If the database limit of 4GB has not been reached, proceed to the Change database to use Unrestricted File Growth section.
   To configure GFI EventsManager to start using a new database, perform the following:
   1. Open the GFI EventsManager Management Console.
   2. Click on the Configuration tab and select Options.
   3. In the right pane, right-click on Database Backend and select Change database backend.
   4. Enter a new name for the database.
      Note: Ensure that another database with that name does not exist.
   5. Click OK to create the new database. GFI EventsManager will now start archiving events to the new database. You will still be able to view events in the old database via the GFI EventsManager Report Center.

Change database to use Unrestricted File Growth:

1. Open Microsoft SQL Server Management Studio Express.
2. Connect to the database server hosting the GFI EventsManager database.
3. Expand the Databases node.
4. Right-click on the GFI EventsManager database and select Properties.
5. Click on the Files node in the left pane.
6. Click on the '...' button for the Data file type under Autogrowth.
7. Under the Maximum File Size section, check Unrestricted File Growth.
   Note: Ensure there is sufficient disk space on the drive where the GFI EventsManager database is stored.

Related Articles

• Moving a GFI EventsManager Database Between Microsoft SQL Servers
• Moving the Microsoft SQL Server Databases by Using Detach and Attach Functions
• Microsoft SQL Server Database Growing Large