Skip to Content
0
Former Member
Jun 06, 2014 at 11:03 AM

Need query/script to truncate Audit DB tables

147 Views

Hi Team,

We are uising SAP BI 4 Sp06. The current SAP BO Production Audit DB size is quite high approx >8 GB, this may have performance impact.

We are planning to Archive Audit DB entry older than March 2014, (Only Archive (Backup) no deletion) .\

As our DB team is not aware about Audit DB structure, they are requesting to provide script to backup/archieve Data upto March.

Any idea how to achieve this?