Purging deleted records

You can purge selected soft deleted records to permanently remove the data from your database. Purged records cannot be restored except from a backup of the database.

About this task

Purge Deleted Records is only available if soft delete is enabled for your database, and if your system administrator has given you access to it.

Procedure

To permanently delete soft deleted records:

  1. Select Edit > Purge Deleted Records.

  2. Specify the age of the records that you want to purge by entering a cutoff date in Deleted before this.

  3. To purge records deleted by a specific user, select the username from the Deleted by this user list.

  4. To find out how many items will be purged from the total number of soft deleted records, turn on Review number of records before purging and click Next to see the statistics.

  5. When you are ready permanently to delete these records, click Purge.

Note: If iBase displays an Error #495 when you attempt to purge soft deleted records, there is likely to be an inconsistency in the iBase database. You can perform a consistency check in iBase Designer. Go to Tools > Administration and complete these actions:

  1. Do a Repair and Compact of the database.

  2. Run a Schema integrity check.

  3. Run a Link integrity check.

iBase checks for inconsistencies and corrects them. You should purge soft deleted records after completing the inconsistency checks. Contact i2 Support if the error persists.