Hello BOB,
Does anyone have recommendations or best practices for archiving the audit database? We want to provide more space in the audit database by keeping data for one year and then archiving all data prior to. Are there any precautions we need to take, so if were archive the data we can easily restore if needed?
I appreciate any knowledge or insight.
Thank you!
Jdog (BOB member since 2006-05-31)
Jdog,
You can have a look at this posting https://bobj-board.org/t/105734, it discusses in an XI scenario the two “transactional” tables in Auditor and a method to delete rows. I suppose that before performing the deletes, that one could write an SQL statement to take the “to be deleted” rows and append to an archival table somewhere, then perform the deletes. Write back if you have any further questions.
Thanks,
John
jsanzone 
(BOB member since 2006-09-12)
Thank you for the response jsanzone! This looks good…though, we will still be taking up space in the database to store the archive table, correct? You think we can copy this archive table to a tape?..I am not a dba, so forgive me if I confuse you with my questions :p.
Jdog (BOB member since 2006-05-31)
Jdog:
Yes, if you simply select data from one table and append it to another, the data still resides in the database, thus you are not diminishing storage needs. Dependent upon your database platform, you have a number of options, and you may have to work with your DBA to implement them. One thing you can do is to use Access to run the query that will grab the rows of data before they get deleted, then your Access file becomes your archive, or if you have the proper tools and DBA expertise, it would be possible to archive what you want to a tape. It all winds up being a matter of convenience and the amount of safety that you want.
jsanzone (BOB member since 2006-09-12)