Restore a database from an ADBZ file

Usually, the system administrator will restore a database from an ADBZ file in the test and production environments using the Alfabet Administrator. Nevertheless, the functionality is also available in Alfabet Expand. for solution designers if they do not have access to the Alfabet Administrator. It is strongly recommended to use the Alfabet Administrator for restore of a database from ADBZ. Never use  Alfabet Expand  for database archive or restore in a production environment!

1. Open the tool Alfabet Expand without logging in to a database.
2. In the menu bar in Alfabet Expand, select Managers > Database Managers > Restore Database Archive. A new window opens.
3. Select a server alias for connection to the Alfabet database that you want to update and click OK. A window for login to the database opens.
4. Enter the user name and password defined for login to the Alfabet database or, if Windows sign on is configured for connections to the Alfabet database, click OK without entering a user name and password.
5. In the dialog box that opens, select the file name and location of the archive file that you want to restore. Alfabet database archive files have the extension ADBZ or ADB.
6. The following options can be selected when restoring the Alfabet database:
   • Include Audit: Deselect the checkbox to exclude audit tables from database restore. De-selection of audit restore can solve restore issues with very large databases.
   • Squeeze Audit Tables: If the checkbox is selected, the audit tables are scanned for obsolete entries. Any entries that were generated during, for example, the batch update of data via batch utilities without documenting any audit relevant changes are deleted from the audit tables restored from the ADBZ file.
7. Click Restore to start the restore process. It may take a few minutes before the restore process is completed.
8. In the Info window that opens, click OK.