How do I delete LM Databases manually? (NETIQKB55608)

In some instances you will run into an issue where the disk used for the Log Database Server fills. One of the only ways to address this is to prune older Log Databases.

You can manually delete one databases, but you must also make manual changes to one of our database tables so that your reporting does not error out.

To do this, perform the following steps:

1. Back up the LM databases you wish to delete.
2. Delete the LM databases you need in order to create 40% free space on the disk.
3. Go into SQL Enterprise Manager and delete the oldest database making note of the database name.
4. Next, in SQL Enterprise Manager browse to Databases -> OnePoint -> Tables.
5. Right click on the MapTable table and select Open Table | Return All Rows.
6. Find the name of the LM database that you deleted and change the Status value from a 3 to a 4.
7. Close the MapTable table.
   

Note: This is only applicable in 6.x for customers who have upgraded from 5.x

Sometimes a 5.x Log Database server can get a full disk. This article details how to remove daily log databases manually.

Formerly known as NETIQKB55608