Database size exceeds the limit in Kaspersky Security Center

Issue

The size of the SQL Server Express (KAV.mdf) database that is used by Kaspersky Security Center exceeds 10 GB.

Cause

The issue occurs if the database reaches the limit of events.

Solution

Check whether the installed database is suitable for your organization:

• Selecting a database
• Calculating the database space

If the recommendations above are followed:

• Make sure that there is enough space on the disk with the database and the database size does not exceed the limit.
• Disable all unnecessary events in the policies for all the managed applications.
• Limit the amount of the events stored in the database.
• Delete unnecessary events using the Administration Console. For details, see these instructions.

If the Administration Server does not run because of the database size limit:

1. Check if you have a recent backup copy of the Administration Server.
2. Remove the Administration Server.
3. Reinstall the Administration Server.
4. Restore data from the backup using the klbackup tool.
5. Disable and delete unnecessary events.

What to do if the issue persists

 

1. Download the all_tables_sizes.zip archive with the .sql file.
2. Create an SQL query using the downloaded .sql file and the klsql2 utility. For details, see the instructions for your version of Kaspersky Security Center.
3. Add the created files to an archive.
4. If the issue persists, use these recommendations and submit a request to Kaspersky technical support via Kaspersky CompanyAccount. Attach the created archive to your request.