asked on

Interbase

Can we compact or repair an interbase database like it exists with a Microsoft access database ?

ASKER CERTIFIED SOLUTION

YodaMage

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

bego

As YodaMage said, IB comes with it's own tools for fixing databases. Moreover, there is a lot utilities over there.

Some notes:
- sweep does not shrink (or compact the database). Once a database allocates some space on the disk, it never releases it - deallocating / reallocating disk space is a costly process and may have impact on database performance. Thus the only way to compact the database is to perform backup / restore.

Example:

rem Project Backup
c:
cd Program Files\Borland\Interbase\Bin
del D:\User\Data\FridayBk.log
gbak -b D:\User\Data\Friday.gdb D:\User\Data\Friday.gbk -user SYSDBA -password masterkey -v -y D:\User\Data\FridayBk.log
pause
rem Backup End

rem Project Restore
c:
cd Program Files\Firebird\Bin
del D:\User\Data\FridayRs.log
gbak -r D:\User\Data\Friday.gbk D:\User\Data\Friday.gdb -user SYSDBA -password masterkey -v -y D:\User\Data\FridayRs.log -p 4096
pause
rem Backup End

For more info on what the switches mean see IB Operations Guide. There you can also find info on repairing database - this process is specific from case to case and there is no universal solution for every problem. Check the Operations Guide. All the docs and lots of more info is available from http://www.ibphoenix.com

HTH,

bego

YodaMage

You all set?

Please close question.