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.

Archiving logs

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.

For SQL Server databases, the database audit log is created as a separate SQL Server database with a name constructed from the database name with the added text _log, for example dbname_log. This database can get large, so you can either:

  • 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 iBase Designer > Tools > Feature Availability > Options > Advanced.

The database password is the same for all databases that are accessed through one security file.