How To Resolve '.qib is too large' Error

Modified on Wed, 08 Jun 2022 at 10:18 AM

Problem Scenario:


During database backup, user may encounter below error message


Physical file of the database becomes too large due to Audit Trail, which contributes up to 80% of the database file size. To resolve this kind of issue, Audit Trail may be dropped. This can result to reduced database size and enhance the system’s performance.

Before proceeding, make sure to duplicate the database (just copy and paste the .FDB file). This is one alternative to do backup but if a scheduled backup is being set, it will not execute anymore.

To delete the Audit Trail, go to File > Audit Trails


Upon window opening, click F9


Key in: qne1080

Notice that there is now a ‘Delete’ button

If the user has preferred range of data to delete only, user may set the following criteria.

Advisable: tick Audit Trail Date and set ‘To’ field to present Date.


Finally click Delete


After doing the above procedure, user may now backup the database, successfully. To totally reduce the database size and improve the system’s performance, restore the created backup file then it will be the one to be used as the working database of all users.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article