email flooding old events

[david freeman_1]

Hi All

Have been running SIM 4.2 SP1 for a while now and been pretty happy with it. All of a sudden today it has started randomly flooding us with thousands of email alerts for old alerts months old.

Today I changed the config of the db to be simple and also truncated the transaction log as it was considerably larger than the db file !

Any thoughts as to if this is related to my problem ?? and if so what I can do to resolve it. I have doubled checked and I am definately on Sp1

Thanks

Dave

[Stuart_43]

I had this issue when my sql server was out of disk space. would think it is a DB issue

[david freeman_1]

No issue with disk space on the server, plenty available.

It appears that everytime the notification jobs run it pumps out every event, like its never marking them as being sent when it runs or something ?

[steve christie_1]

I had this issue with the transaction log. Right click the database and go to properties/options, make sure the recovery type is set to simple and not full. This should drop the size down considerably

[steve christie_1]

have you backed up your transaction log, this should purge all old transactions.

[david freeman_1]

Yes the problem really started happening after I backed up and changed my db type.

I have rebuilt the server as it flooded our mail system so much they were queued and still coming through 4 hours after I turned off the server.... lets start again.