Archiving audit logs
For iBase databases in Microsoft™ Access format, you can archive audit logs by using the Audit Viewer and then reopen the archive also in Audit Viewer. For iBase databases in SQL Server format, you can archive audit logs to a new SQL Server database that Audit Viewer creates for you.
If you want to archive logs using tools external to iBase and Audit Viewer, you need to know where the logs are stored. Different locations are used for different types of databases and logs.
For Access databases, the database log is held in the _AuditLog table of the .idl file that is stored in the same folder.
- Use Audit Viewer to extract sections to store as archives. For more information, see Archiving SQL Server databases.
- Use a Microsoft SQL Server backup tool to archive the whole log, and then delete the audit log database. After you delete the audit log database, open the main database in iBase designer to create a blank audit log database.
Opening an archive in Microsoft Access
For iBase databases in Microsoft Access format, the audit log is held as an archive file, .idla, a password-protected database file.
The password for Access databases is the database password, which is listed in.
The database password is the same for all databases that are accessed through one security file.