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.

About this task

When you archive data, it is no longer accessible from within Audit Viewer. You will need the assistance of an SQL Server administrator to retrieve specific log entries or run reports.

Procedure

To save part of the audit log to an 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 Server Name list, select the machine on which you want to create the new database. This can be your local SQL Server.

  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.