We are preparing to do some testing on purging various logs in our database prior to upgrading to E10.
I am familiar with the screen for purging logs but I want to have more specific info from our SQL database.
I can right click the database and run -reports -standard reports -disk usage by table, but it isn’t clear to me which tables are specifically affected by the purge process. Some table names have “log” in them others don’t.
For starters I am interested in these tables based on the descriptor
- Job Audit Log
- Labor Detail Log
- Labor Header Log
Can someone please provide some clarification so I can document specifically which tables are affected by what ?