Skip to Content

Audit Data Archive - Back end table details required

Jun 13, 2017 at 09:44 AM


avatar image

Hi Experts,

1. I want some help on how to know the size of table containing audit data?

2. What is standard practice for house keeping of audit data. i.e. Up to how much number of entries / Up to how much size it is advisable to have in audit data table?

I have gone through the following link:

but it does not containing any above required details.



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Vadim Kalinin Jun 13, 2017 at 09:50 AM

Audit data storage depends on business requirements. It has to be some common cense discussion with finance people to define the required period (keeping in mind that in critical cases the audit data can be restored from old full server backup). After period is defined you have to provide enough space and server capacity.

P.S. In general it's hard to predict audit table growth. In some cases after running DM package multiple times the growth can be significant...

10 |10000 characters needed characters left characters exceeded