How To Resolve '.qib is too large' Error

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

Problem Scenario:

 

During database backup, user may encounter below error message




Resolution(s):

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 at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article