How Do I delete alarms and events from Citadel database?

[SnowForest]

Hello,

I'm using LV 2010 with DSC.

I made an error in my program and I wrote too much event and alarm data to citadel. Database files *.mdf/*.ldf are quite large >1G. Normally I log only couple of alarms per day. I want delete all alarm+event data before certain time time stamp e.g.. 1.1.2011. How I can do that? I tried use MAX and achieve operation as well I wrote small program which achieve data to temp database and then remove it. Still I can find old events and alarms..I'm able to remove old traces but not events/alarms. How I can remove alarms/events ?

Thanks, Jim

[AdnanZ · Accepted solution]

Hi Jim,

Have you seen this:

http://forums.ni.com/t5/Lookout/How-can-I-delete-alarm-and-event-data-from-a-Citadel5-database/m-p/5...

Not sure if it's valid with the current version but worth a shot.

[SnowForest]

Hi Adnan,

Thanks a lot this will solve the problem. I can't understand why there is not ready made VIs functions to do this removing.

BR, Jim

[AdnanZ]

I am not sure about that either. Maybe it's a good product suggestion?

[SnowForest]

Hi Adnan,

I noticed that after deleting alarms transaction log file increased and main database size file stayed as it was before deleting. My main target was reduce database size but this operation double database size. I rebooted computer but still database is "huge".

I know that it is possible to do shrinking operation in SQL server but I don't know is it possible do that in Citadel. Do you have idea how to shrink database files after deleting alarms?