Archiving SQL Server databases

You can save the audit log for an iBase SQL Server database to a new SQL Server database on a different server machine (a linked server), or on the same SQL Server as your iBase database.

Procedure

To save part of the audit log to a new SQL Server database (and then delete those records from the audit log):
  1. Open the database audit log.
  2. Select Action > Archive.
  3. From the Linked Server Name list, select the machine on which you want to create the new database.
  4. Enter the name of the new database.
  5. Enter the name and password for a user who has permission to create databases on this machine.
  6. Enter the cutoff date for the archive. All audit log entries before this date will be deleted from the audit log.
    You can inspect archived audit logs in Audit Viewer. Log on to Audit Viewer and select Open SQL Server Archive from the File menu.