HPSIM deleting records problem

[Manuel Wodrich]

At the beginning of this week, our MSDE ran out of space(2GB limitations).
(Right now theire is no option raising the MSDE to a fully SQL-Server, so don't suggest this option please. ;-) ). So i transfered the DB to another Server, were an fully SQL-Server is installed. That all went okay.
Now i want to reduce my DB, so i can go back to my MSDE on the localhost.
Now i have 380000 "Uncleared Event Status" records which i want to remove,
to shrink my DB.
If i go to System Overview, i get to see how many records are actually theire.
I klick on the link, to see those records, but eventually i do not get to see them.
Server takes about 40 Minutes to bring up anything, and what i see iss nothing. No records are shown.
I already tried to delete those records through a task, but without any results.
Records get still shown.
I guess that all is a problem, because of the remote SQL-Server, or because of the numbers of records listed. :-)
Anyway, i will need to get rid of those records, if i will have any change to shrink my DB, to a limit, that my MSDE will hold again the DB.

Does anyone has a solution for my problem,
or can eventually tell my, in which table those records are actually hold, and which tables i will have clean up too, to get rid of those records?

If performance will be fine, and DB is not getting to shrink to the limitation size of the MSDE, i will leave it on the remote SQL-Server.

But still i want to loose those records. :-D

[Aravindh Rajaram]

All the events are available in the "notices" table. You can delete any event that is NOT having the noticeType "1".

[Manuel Wodrich]

Hello, i looked in the table you mentioned("notices").
Yes theire are a lot of records in it, but i found another table, that holds the same amount of records, and seems quit larger, than the table "notices". The table i mean is the "trapData". It seems to hold all the traps, that where sended, and not being deleted.
I need to clean all the tables, which hold any references to those records, to be sure everything is cleaned out, and not just clean up one table, and leave any referenced table filled with data, that doesn't need to be in anymore.
"notices" is a good start though.
Anymore tables that need to be cleaned out?

[Manuel Wodrich]

Okay!
Here is an update.
I cleaned up "notices" like mentioned.
By the way, this database did hold the records, but wasn't responsible for the DBsize.
Additionally i cleaned out the table "trapData", which also holded the amount of records. This table was indead responsible, for the size of our DB.
Now the DB is down again, from 2,4 GB to 600 MB. *Puuh*
Sofar the Application is running fine, and we had no issues.


At this point thanks sofar for your little help AMicSys.