Purge the EdiInt_InboundMessageIdentity Table

Question

We used to have a solution using EDI/AS2, but this application is no longer in use /existence - but this Table has over 2 million records in it.

I can't see any reason why this table can't be truncated to remove all the redundant data - i can't see any links to it, it's just used in the SP's to add a new record or query existing data.

Am i missing something - or is it really this simple?

Answer 1

I'm pretty sure this table supports the non-repudiation features of AS2.  So, it's not totally surprising it isn't cleaned up automatically.

Now, 2 million records isn't really a lot but if the app isn't used anymore, the data should be cleaned up.

My recommendation would be during a downtime, backup MsgBoxDb, export the table and truncate.