In this task you will use the Backup Manager to perform a Backup and Restore process to optimize your database performance.
The Backup Manager is accessed from the server
The Backup Manager is accessed from the server by clicking Windows Start – DBA Manufacturing – Utilities – Backup Manager.
Backup and Restore
Use this menu option to perform a GBAK backup and restore in a single process. We recommend running this process on a periodic basis, such as once a quarter, to maintain optimal database performance.
GBAK boosts database performance
The backup and restore process uses the GBAK utility supplied with the Firebird database. GBAK boosts database performance by doing the following:
•Rebuilds indices
•Eliminates obsolete record versions ("garbage")
•Defragment database pages
•Rewrites database tables contiguously
So whenever you restore from a GBAK backup, your database is optimized to be smaller and more efficient.
Link:
